CREATE database if NOT EXISTS `fisp` default character set utf8mb4 collate utf8mb4_general_ci;
use `fisp`;

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50720
 Source Host           : localhost:3306
 Source Schema         : fisp

 Target Server Type    : MySQL
 Target Server Version : 50720
 File Encoding         : 65001

 Date: 21/10/2021 12:37:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint(20) unsigned NOT NULL COMMENT '主键Id',
  `login_name` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '用户登录名称',
  `password` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '密码',
  `show_name` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户显示名称',
  `dept_id` bigint(20) unsigned NOT NULL COMMENT '用户所在部门Id',
  `user_type` int(11) NOT NULL COMMENT '用户类型(0: 管理员 1: 系统管理用户 2: 系统业务用户)',
  `head_image_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户头像的Url',
  `user_status` int(11) NOT NULL COMMENT '状态(0: 正常 1: 锁定)',
  `create_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '创建者Id',
  `create_user_name` varchar(32) DEFAULT NULL COMMENT '创建者显示名称',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '更新者Id',
  `update_user_name` varchar(32) DEFAULT NULL COMMENT '更新者显示名称',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  `deleted_flag` int(1) NOT NULL DEFAULT '0' COMMENT '删除标记(0: 正常 1: 已删除)',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `uk_login_name` (`login_name`) USING BTREE,
  KEY `idx_dept_id` (`dept_id`) USING BTREE,
  KEY `idx_status` (`user_status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='系统用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1440911410581213417, 'admin', '$2a$10$GT/GXfypSJ.2f7.npoAAHuINPkC/VJttDGYBB3xyQqWt1bi9qEnL6', '管理员', 1440911410581213416, 0, 'CHANGE TO YOUR HEAD IMAGE URL!!!', 0, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_user` VALUES (1440965344985354240, 'leaderHR', '$2a$10$tLqussQ4t4n..A274vS9luxZI8zmxdQSkmwXcOU3egPJtyFIVDYj.', '人事经理', 1440963592970047488, 2, NULL, 0, 1440911410581213417, '管理员', '2021-09-23 17:04:45', 1440911410581213417, '管理员', '2021-09-23 17:04:45', 0);
INSERT INTO `sys_user` VALUES (1440965465605148672, 'userA', '$2a$10$BGsgE5KA/hKV95.kCZmMleiUssNRpOGE0qMTkCGHsSiugnqSsaSFS', '员工A', 1440963592970047488, 2, NULL, 0, 1440911410581213417, '管理员', '2021-09-23 17:05:14', 1440911410581213417, '管理员', '2021-09-23 17:05:14', 0);
INSERT INTO `sys_user` VALUES (1440965586715676672, 'userB', '$2a$10$J0obwzeNt3iWoArSdRCKLeABdcMwe/rJrPIoGNW.LFgCYKhFKC9Lu', '员工B', 1440963642542526464, 2, NULL, 0, 1440911410581213417, '管理员', '2021-09-23 17:05:42', 1440911410581213417, '管理员', '2021-09-23 17:05:42', 0);
INSERT INTO `sys_user` VALUES (1440965697961201664, 'userC', '$2a$10$KukIvoMoncnpSafKnueXnOLEhI5V7cW0GBsGt9EkTGq482vsRgQwm', '员工C', 1440963642542526464, 2, NULL, 0, 1440911410581213417, '管理员', '2021-09-23 17:06:09', 1440911410581213417, '管理员', '2021-09-23 17:06:09', 0);
INSERT INTO `sys_user` VALUES (1440965808049098752, 'leaderLaw', '$2a$10$8o2qUYKOpizH42gIs4hDU.TjrzzWu/tOJeQebvXISkAI3wscFbAl2', '法务经理', 1440963642542526464, 2, NULL, 0, 1440911410581213417, '管理员', '2021-09-23 17:06:35', 1440911410581213417, '管理员', '2021-09-23 17:06:35', 0);
INSERT INTO `sys_user` VALUES (1440966073686953984, 'leaderTJ', '$2a$10$NLZDkFP/nLkGzo/blYJ7w.HmmZF8v12ByockmYXPZZ7cr/TqILB/u', '天津总监', 1440963698460987392, 2, NULL, 0, 1440911410581213417, '管理员', '2021-09-23 17:07:39', 1440911410581213417, '管理员', '2021-09-23 17:07:39', 0);
INSERT INTO `sys_user` VALUES (1440966186522120192, 'leaderTJ2', '$2a$10$F7vVIJeC7OdHTNV050aqieJwJcBdjrUOCGjAE4wq0mESLb1Pn6yoe', '天津经理', 1440963698460987392, 2, NULL, 0, 1440911410581213417, '管理员', '2021-09-23 17:08:05', 1440911410581213417, '管理员', '2021-09-23 17:08:05', 0);
INSERT INTO `sys_user` VALUES (1440966324770574336, 'userD', '$2a$10$7G2Lcw1GducD2FtCxQask.7lVRPRvKZk7YVZOsT319uXVtK2LQPji', '员工D', 1440963698460987392, 2, NULL, 0, 1440911410581213417, '管理员', '2021-09-23 17:08:38', 1440911410581213417, '管理员', '2021-09-23 17:08:38', 0);
INSERT INTO `sys_user` VALUES (1440969706411397120, 'leader', '$2a$10$LgJRx/7YT.F6oUs4PPVpxuSYQBOdcXqx6dvdkaJmA7ObWdpJzhOQu', '总部领导', 1440911410581213416, 2, NULL, 0, 1440911410581213417, '管理员', '2021-09-23 17:22:05', 1440911410581213417, '管理员', '2021-09-23 17:22:05', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `dept_id` bigint(20) unsigned NOT NULL COMMENT '部门Id',
  `parent_id` bigint(20) unsigned DEFAULT NULL COMMENT '父部门Id',
  `dept_name` varchar(50) COLLATE utf8mb4_bin NOT NULL COMMENT '部门名称',
  `show_order` int(11) NOT NULL COMMENT '兄弟部门之间的显示顺序，数字越小越靠前',
  `create_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '创建者Id',
  `create_user_name` varchar(32) DEFAULT NULL COMMENT '创建者显示名称',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '更新者Id',
  `update_user_name` varchar(32) DEFAULT NULL COMMENT '更新者显示名称',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  `deleted_flag` int(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除标记(0: 正常 1: 已删除)',
  PRIMARY KEY (`dept_id`) USING BTREE,
  KEY `idx_parent_id` (`parent_id`) USING BTREE,
  KEY `idx_show_order` (`show_order`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='部门管理表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES (1440911410581213416, NULL, '公司总部', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_dept` VALUES (1440963592970047488, 1440911410581213416, '人事部', 1, 1440911410581213417, '管理员', '2021-09-23 16:57:47', 1440911410581213417, '管理员', '2021-09-23 16:57:47', 0);
INSERT INTO `sys_dept` VALUES (1440963642542526464, 1440911410581213416, '法务部', 2, 1440911410581213417, '管理员', '2021-09-23 16:57:59', 1440911410581213417, '管理员', '2021-09-23 16:57:59', 0);
INSERT INTO `sys_dept` VALUES (1440963698460987392, NULL, '天津分公司', 2, 1440911410581213417, '管理员', '2021-09-23 16:58:12', 1440911410581213417, '管理员', '2021-09-23 16:58:12', 0);
INSERT INTO `sys_dept` VALUES (1440963733084966912, NULL, '北京分公司', 2, 1440911410581213417, '管理员', '2021-09-23 16:58:20', 1440911410581213417, '管理员', '2021-09-23 16:58:20', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_dept_relation
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept_relation`;
CREATE TABLE `sys_dept_relation` (
  `parent_dept_id` bigint(20) unsigned NOT NULL COMMENT '父部门Id',
  `dept_id` bigint(20) unsigned NOT NULL COMMENT '部门Id',
  PRIMARY KEY (`parent_dept_id`,`dept_id`),
  KEY `idx_dept_id` (`dept_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='部门关联关系表';

-- ----------------------------
-- Records of sys_dept_relation
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept_relation` VALUES (1440911410581213416, 1440911410581213416);
INSERT INTO `sys_dept_relation` VALUES (1440911410581213416, 1440963592970047488);
INSERT INTO `sys_dept_relation` VALUES (1440963592970047488, 1440963592970047488);
INSERT INTO `sys_dept_relation` VALUES (1440911410581213416, 1440963642542526464);
INSERT INTO `sys_dept_relation` VALUES (1440963642542526464, 1440963642542526464);
INSERT INTO `sys_dept_relation` VALUES (1440963698460987392, 1440963698460987392);
INSERT INTO `sys_dept_relation` VALUES (1440963733084966912, 1440963733084966912);
COMMIT;

-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;
CREATE TABLE `sys_post` (
  `post_id` bigint(20) unsigned NOT NULL COMMENT '岗位Id',
  `post_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '岗位名称',
  `level` int(11) NOT NULL COMMENT '岗位层级，数值越小级别越高',
  `leader_post` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否领导岗位',
  `create_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '创建者Id',
  `create_user_name` varchar(32) DEFAULT NULL COMMENT '创建者显示名称',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '更新者Id',
  `update_user_name` varchar(32) DEFAULT NULL COMMENT '更新者显示名称',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  `deleted_flag` int(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除标记(0: 正常 1: 已删除)',
  PRIMARY KEY (`post_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='岗位信息表';

-- ----------------------------
-- Records of sys_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_post` VALUES (1440963890539139072, '总经理', 1, b'1', 1440911410581213417, '管理员', '2021-09-23 16:58:58', 1440911410581213417, '管理员', '2021-09-23 16:59:27', 0);
INSERT INTO `sys_post` VALUES (1440964040611336192, '副经理', 2, b'1', 1440911410581213417, '管理员', '2021-09-23 16:59:34', 1440911410581213417, '管理员', '2021-09-23 16:59:34', 0);
INSERT INTO `sys_post` VALUES (1440964097913917440, '组长', 10, b'1', 1440911410581213417, '管理员', '2021-09-23 16:59:47', 1440911410581213417, '管理员', '2021-09-23 16:59:47', 0);
INSERT INTO `sys_post` VALUES (1440964131539652608, '副组长', 11, b'1', 1440911410581213417, '管理员', '2021-09-23 16:59:55', 1440911410581213417, '管理员', '2021-09-23 16:59:55', 0);
INSERT INTO `sys_post` VALUES (1440964157770829824, '组员', 20, b'0', 1440911410581213417, '管理员', '2021-09-23 17:00:02', 1440911410581213417, '管理员', '2021-09-23 17:00:02', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_dept_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept_post`;
CREATE TABLE `sys_dept_post` (
  `dept_post_id` bigint(20) unsigned NOT NULL COMMENT '主键Id',
  `dept_id` bigint(20) unsigned NOT NULL COMMENT '部门Id',
  `post_id` bigint(20) unsigned NOT NULL COMMENT '岗位Id',
  `post_show_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '部门岗位显示名称',
  PRIMARY KEY (`dept_post_id`) USING BTREE,
  KEY `idx_post_id` (`post_id`) USING BTREE,
  KEY `idx_dept_id` (`dept_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='部门岗位信息表';

-- ----------------------------
-- Records of sys_dept_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept_post` VALUES (1440964221780103168, 1440963592970047488, 1440964097913917440, '人事部经理');
INSERT INTO `sys_dept_post` VALUES (1440964221855600640, 1440963592970047488, 1440964157770829824, '人事专员');
INSERT INTO `sys_dept_post` VALUES (1440964387979399168, 1440963642542526464, 1440964097913917440, '法务部经理');
INSERT INTO `sys_dept_post` VALUES (1440964387983593472, 1440963642542526464, 1440964157770829824, '法务专员');
INSERT INTO `sys_dept_post` VALUES (1440964519391137792, 1440963698460987392, 1440963890539139072, '天津大区总监');
INSERT INTO `sys_dept_post` VALUES (1440964519395332096, 1440963698460987392, 1440964040611336192, '天津地区经理');
INSERT INTO `sys_dept_post` VALUES (1440964519399526400, 1440963698460987392, 1440964157770829824, '员工');
INSERT INTO `sys_dept_post` VALUES (1440964725134331904, 1440963733084966912, 1440963890539139072, '北京大区总监');
INSERT INTO `sys_dept_post` VALUES (1440964725138526208, 1440963733084966912, 1440964040611336192, '北京地区经理');
INSERT INTO `sys_dept_post` VALUES (1440964725142720512, 1440963733084966912, 1440964157770829824, '员工');
INSERT INTO `sys_dept_post` VALUES (1440969551792574464, 1440911410581213416, 1440963890539139072, '总裁');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_post`;
CREATE TABLE `sys_user_post` (
  `user_id` bigint(20) unsigned NOT NULL COMMENT '用户Id',
  `dept_post_id` bigint(20) unsigned NOT NULL COMMENT '部门岗位Id',
  `post_id` bigint(20) unsigned NOT NULL COMMENT '岗位Id',
  PRIMARY KEY (`user_id`,`dept_post_id`) USING BTREE,
  KEY `idx_post_id` (`post_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户关联部门岗位表';

-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_post` VALUES (1440966073686953984, 1440964519391137792, 1440963890539139072);
INSERT INTO `sys_user_post` VALUES (1440969706411397120, 1440969551792574464, 1440963890539139072);
INSERT INTO `sys_user_post` VALUES (1440966186522120192, 1440964519395332096, 1440964040611336192);
INSERT INTO `sys_user_post` VALUES (1440965344985354240, 1440964221780103168, 1440964097913917440);
INSERT INTO `sys_user_post` VALUES (1440965808049098752, 1440964387979399168, 1440964097913917440);
INSERT INTO `sys_user_post` VALUES (1440965465605148672, 1440964221855600640, 1440964157770829824);
INSERT INTO `sys_user_post` VALUES (1440965586715676672, 1440964387983593472, 1440964157770829824);
INSERT INTO `sys_user_post` VALUES (1440965697961201664, 1440964387983593472, 1440964157770829824);
INSERT INTO `sys_user_post` VALUES (1440966324770574336, 1440964519399526400, 1440964157770829824);
COMMIT;

-- ----------------------------
-- Table structure for sys_perm_module
-- ----------------------------
DROP TABLE IF EXISTS `sys_perm_module`;
CREATE TABLE `sys_perm_module` (
  `module_id` bigint(20) unsigned NOT NULL COMMENT '权限模块id',
  `parent_id` bigint(20) unsigned DEFAULT '0' COMMENT '上级权限模块id',
  `module_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '权限模块名称',
  `module_type` int(11) NOT NULL COMMENT '模块类型(0: 普通模块 1: Controller模块)',
  `show_order` int(11) NOT NULL DEFAULT '0' COMMENT '权限模块在当前层级下的顺序，由小到大',
  `create_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '创建者Id',
  `create_user_name` varchar(32) DEFAULT NULL COMMENT '创建者显示名称',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '更新者Id',
  `update_user_name` varchar(32) DEFAULT NULL COMMENT '更新者显示名称',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  `deleted_flag` int(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除标记(0: 正常 1: 已删除)',
  PRIMARY KEY (`module_id`) USING BTREE,
  KEY `idx_show_order` (`show_order`) USING BTREE,
  KEY `idx_parent_id` (`parent_id`) USING BTREE,
  KEY `idx_module_type` (`module_type`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='系统权限模块表';

-- ----------------------------
-- Records of sys_perm_module
-- ----------------------------
BEGIN;
INSERT INTO `sys_perm_module` VALUES (1400625106979393536, NULL, '在线表单', 0, 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1400625224646397952, 1400625106979393536, '数据库连接', 1, 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1400625338886656000, 1400625106979393536, '页面管理', 1, 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1400625585851469824, 1400625106979393536, '在线表单字典管理', 1, 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1400625800033603584, 1400625106979393536, '数据表管理', 1, 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1400625906245963776, 1400625106979393536, '数据表字段', 1, 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1400626018774945792, 1400625106979393536, '字段验证规则', 1, 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1400626192725315584, 1400625106979393536, '数据源管理', 1, 7, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1400626237478539264, 1400625106979393536, '数据源关联', 1, 8, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1400626463740268544, 1400625106979393536, '表单管理', 1, 9, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1401532052901203970, NULL, '用户权限', 0, 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1401532056508305408, NULL, '系统配置', 0, 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1401532056508305409, NULL, '缺省分组', 0, 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1413404952566435840, 1400625106979393536, '虚拟字段管理', 1, 10, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1418028920103505920, NULL, '流程管理', 0, 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1418029566533832704, 1418028920103505920, '流程分类', 1, 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1418029615040958464, 1418028920103505920, '流程设计', 1, 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1418030256765276160, 1418028920103505920, '流程操作', 1, 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1418031999276290048, 1418028920103505920, '流程变量', 1, 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1418038955105849344, NULL, '工单列表', 0, 7, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1418051228918616064, 1418028920103505920, '启动流程', 1, 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1418051634793025536, 1418028920103505920, '审批流程', 1, 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1418054414190514176, 1418028920103505920, '流程审批数据', 1, 7, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1423635643371622400, 1418028920103505920, '已办任务', 1, 8, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1440911410581213184, 1401532052901203970, '部门管理', 1, 0, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1440911410581213198, 1401532052901203970, '用户管理', 1, 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1440911410581213210, 1401532052901203970, '角色管理', 1, 10, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1440911410581213222, 1401532052901203970, '数据权限管理', 1, 15, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1440911410581213232, 1401532052901203970, '岗位管理', 1, 20, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1440911410581213238, 1401532052901203970, '菜单管理', 1, 25, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1440911410581213246, 1401532052901203970, '权限字管理', 1, 30, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1440911410581213254, 1401532052901203970, '权限模块管理', 1, 35, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1440911410581213260, 1401532052901203970, '权限资源管理', 1, 40, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1440911410581213269, 1401532056508305408, '字典管理', 0, 0, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1440911410581213270, 1440911410581213269, '行政区划', 1, 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1440911410581213275, 1401532056508305408, '在线用户', 1, 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_module` VALUES (1440975375537541120, 1418038955105849344, '请假申请', 1, 1, 1440911410581213417, '管理员', '2021-09-23 17:44:36', 1440911410581213417, '管理员', '2021-09-23 17:44:36', 0);
INSERT INTO `sys_perm_module` VALUES (1440975429199466496, 1418038955105849344, '报销申请', 1, 2, 1440911410581213417, '管理员', '2021-09-23 17:44:49', 1440911410581213417, '管理员', '2021-09-23 17:44:49', 0);
INSERT INTO `sys_perm_module` VALUES (1440975469133434880, 1418038955105849344, '合同审批', 1, 3, 1440911410581213417, '管理员', '2021-09-23 17:44:59', 1440911410581213417, '管理员', '2021-09-23 17:44:59', 0);
INSERT INTO `sys_perm_module` VALUES (1440975527128076288, 1418038955105849344, '多实例加签', 1, 4, 1440911410581213417, '管理员', '2021-09-23 17:45:12', 1440911410581213417, '管理员', '2021-09-23 17:45:12', 0);
INSERT INTO `sys_perm_module` VALUES (1440975571776442368, 1418038955105849344, '转办流程', 1, 5, 1440911410581213417, '管理员', '2021-09-23 17:45:23', 1440911410581213417, '管理员', '2021-09-23 17:45:32', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_perm
-- ----------------------------
DROP TABLE IF EXISTS `sys_perm`;
CREATE TABLE `sys_perm` (
  `perm_id` bigint(20) unsigned NOT NULL COMMENT '权限id',
  `module_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '权限所在的权限模块id',
  `perm_name` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '权限名称',
  `url` varchar(128) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '关联的url',
  `show_order` int(11) NOT NULL DEFAULT '0' COMMENT '权限在当前模块下的顺序，由小到大',
  `create_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '创建者Id',
  `create_user_name` varchar(32) DEFAULT NULL COMMENT '创建者显示名称',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '更新者Id',
  `update_user_name` varchar(32) DEFAULT NULL COMMENT '更新者显示名称',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  `deleted_flag` int(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除标记(0: 正常 1: 已删除)',
  PRIMARY KEY (`perm_id`) USING BTREE,
  KEY `idx_show_order` (`show_order`) USING BTREE,
  KEY `idx_module_id` (`module_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='权限资源表';

-- ----------------------------
-- Records of sys_perm
-- ----------------------------
BEGIN;
INSERT INTO `sys_perm` VALUES (1400626748101496832, 1400625224646397952, '显示列表', '/admin/online/onlineDblink/list', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400626963806162944, 1400625224646397952, '数据表列表', '/admin/online/onlineDblink/listDblinkTables', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400627109692444672, 1400625224646397952, '数据表字段列表', '/admin/online/onlineDblink/listDblinkTableColumns', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400632108514283520, 1400625585851469824, '显示列表', '/admin/online/onlineDict/list', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400632216169484288, 1400625585851469824, '详情', '/admin/online/onlineDict/view', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400632326538399744, 1400625585851469824, '新增', '/admin/online/onlineDict/add', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400632438635368448, 1400625585851469824, '编辑', '/admin/online/onlineDict/update', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400632511620452352, 1400625585851469824, '删除', '/admin/online/onlineDict/delete', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400632924021198848, 1400625800033603584, '显示列表', '/admin/online/onlineTable/list', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400632978937221120, 1400625800033603584, '详情', '/admin/online/onlineTable/view', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400633026181861376, 1400625800033603584, '新增', '/admin/online/onlineTable/add', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400633077717274624, 1400625800033603584, '编辑', '/admin/online/onlineTable/update', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400633129688895488, 1400625800033603584, '删除', '/admin/online/onlineTable/delete', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400633375525441536, 1400625906245963776, '显示列表', '/admin/online/onlineColumn/list', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400633437093629952, 1400625906245963776, '详情', '/admin/online/onlineColumn/view', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400633529678696448, 1400625906245963776, '新增', '/admin/online/onlineColumn/add', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400633568027217920, 1400625906245963776, '编辑', '/admin/online/onlineColumn/update', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400633612201627648, 1400625906245963776, '删除', '/admin/online/onlineColumn/delete', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400633713376628736, 1400625906245963776, '刷新字段', '/admin/online/onlineColumn/refresh', 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400633798403559424, 1400625906245963776, '字段验证规则列表', '/admin/online/onlineColumn/listOnlineColumnRule', 7, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400633922085195776, 1400625906245963776, '未使用字段验证规则列表', '/admin/online/onlineColumn/listNotInOnlineColumnRule', 8, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400634012745076736, 1400625906245963776, '添加字段验证规则', '/admin/online/onlineColumn/addOnlineColumnRule', 9, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400634100498305024, 1400625906245963776, '删除字段验证规则', '/admin/online/onlineColumn/deleteOnlineColumnRule', 10, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400634280308117504, 1400625906245963776, '编辑字段验证规则', '/admin/online/onlineColumn/updateOnlineColumnRule', 11, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400634354593435648, 1400625906245963776, '字段验证规则详情', '/admin/online/onlineColumn/viewOnlineColumnRule', 12, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400634559896227840, 1400626018774945792, '显示列表', '/admin/online/onlineRule/list', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400634613151305728, 1400626018774945792, '详情', '/admin/online/onlineRule/view', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400634651944423424, 1400626018774945792, '新增', '/admin/online/onlineRule/add', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400634693472227328, 1400626018774945792, '编辑', '/admin/online/onlineRule/update', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400634735549485056, 1400626018774945792, '删除', '/admin/online/onlineRule/delete', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400635131969933312, 1400625338886656000, '显示列表', '/admin/online/onlinePage/list', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400635267726970880, 1400625338886656000, '页面以及表单列表', '/admin/online/onlinePage/listAllPageAndForm', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400635341274091520, 1400625338886656000, '详情', '/admin/online/onlinePage/view', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400635378506928128, 1400625338886656000, '新增', '/admin/online/onlinePage/add', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400635426808532992, 1400625338886656000, '编辑', '/admin/online/onlinePage/update', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400635527698321408, 1400625338886656000, '更新启用状态', '/admin/online/onlinePage/updatePublished', 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400635581532213248, 1400625338886656000, '删除', '/admin/online/onlinePage/delete', 7, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400635661106548736, 1400625338886656000, '页面数据源列表', '/admin/online/onlinePage/listOnlinePageDatasource', 8, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400635757332271104, 1400625338886656000, '未使用页面数据源列表', '/admin/online/onlinePage/listNotInOnlinePageDatasource', 9, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400635827347787776, 1400625338886656000, '添加页面数据源', '/admin/online/onlinePage/addOnlinePageDatasource', 10, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400635896461529088, 1400625338886656000, '删除页面数据源', '/admin/online/onlinePage/deleteOnlinePageDatasource', 11, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400635963469729792, 1400625338886656000, '编辑页面数据源', '/admin/online/onlinePage/updateOnlinePageDatasource', 12, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400636031752998912, 1400625338886656000, '页面数据源详情', '/admin/online/onlinePage/viewOnlinePageDatasource', 13, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400636182936686592, 1400626192725315584, '显示列表', '/admin/online/onlineDatasource/list', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400636217728438272, 1400626192725315584, '详情', '/admin/online/onlineDatasource/view', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400636258107002880, 1400626192725315584, '新增', '/admin/online/onlineDatasource/add', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400636301480300544, 1400626192725315584, '编辑', '/admin/online/onlineDatasource/update', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400636338838966272, 1400626192725315584, '删除', '/admin/online/onlineDatasource/delete', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400636501900922880, 1400626237478539264, '显示列表', '/admin/online/onlineDatasourceRelation/list', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400636535371468800, 1400626237478539264, '详情', '/admin/online/onlineDatasourceRelation/view', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400636571165659136, 1400626237478539264, '新增', '/admin/online/onlineDatasourceRelation/add', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400636610403373056, 1400626237478539264, '编辑', '/admin/online/onlineDatasourceRelation/update', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400636656679129088, 1400626237478539264, '删除', '/admin/online/onlineDatasourceRelation/delete', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400637740705386496, 1400626463740268544, '显示列表', '/admin/online/onlineForm/list', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400637775962705920, 1400626463740268544, '详情', '/admin/online/onlineForm/view', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400637822737584128, 1400626463740268544, '新增', '/admin/online/onlineForm/add', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400637858414333952, 1400626463740268544, '编辑', '/admin/online/onlineForm/update', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400637895328403456, 1400626463740268544, '删除', '/admin/online/onlineForm/delete', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1400637970863624192, 1400626463740268544, '渲染信息', '/admin/online/onlineForm/render', 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1413405061278601216, 1413404952566435840, '显示列表', '/admin/online/onlineVirtualColumn/list', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1413405166471745536, 1413404952566435840, '详情', '/admin/online/onlineVirtualColumn/view', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1413405224021790720, 1413404952566435840, '新增', '/admin/online/onlineVirtualColumn/add', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1413405313788284928, 1413404952566435840, '编辑', '/admin/online/onlineVirtualColumn/update', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1413405352866615296, 1413404952566435840, '删除', '/admin/online/onlineVirtualColumn/delete', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418030338508066816, 1418029566533832704, '显示列表', '/admin/flow/flowCategory/list', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418030386436378624, 1418029566533832704, '新增', '/admin/flow/flowCategory/add', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418030437971791872, 1418029566533832704, '编辑', '/admin/flow/flowCategory/update', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418030477918343168, 1418029566533832704, '删除', '/admin/flow/flowCategory/delete', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418030533757112320, 1418029566533832704, '详情', '/admin/flow/flowCategory/view', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418031006660694016, 1418029615040958464, '显示列表', '/admin/flow/flowEntry/list', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418031078391681024, 1418029615040958464, '新增', '/admin/flow/flowEntry/add', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418031120481521664, 1418029615040958464, '编辑', '/admin/flow/flowEntry/update', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418031174604820480, 1418029615040958464, '删除', '/admin/flow/flowEntry/delete', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418031219706171392, 1418029615040958464, '详情', '/admin/flow/flowEntry/view', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418031304779239424, 1418029615040958464, '发布', '/admin/flow/flowEntry/publish', 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418031515207471104, 1418029615040958464, '流程版本列表', '/admin/flow/flowEntry/listFlowEntryPublish', 7, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418031648351457280, 1418029615040958464, '设置主版本', '/admin/flow/flowEntry/updateMainVersion', 8, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418031712788549632, 1418029615040958464, '挂起', '/admin/flow/flowEntry/suspendFlowEntryPublish', 9, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418031801271586816, 1418029615040958464, '激活', '/admin/flow/flowEntry/activateFlowEntryPublish', 10, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418032222232907776, 1418031999276290048, '显示列表', '/admin/flow/flowEntryVariable/list', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418032258429751296, 1418031999276290048, '新增', '/admin/flow/flowEntryVariable/add', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418032300414734336, 1418031999276290048, '编辑', '/admin/flow/flowEntryVariable/update', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418032344064856064, 1418031999276290048, '删除', '/admin/flow/flowEntryVariable/delete', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418032382409183232, 1418031999276290048, '详情', '/admin/flow/flowEntryVariable/view', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418033804987076608, 1418030256765276160, '流程实例列表', '/admin/flow/flowOperation/listAllHistoricProcessInstance', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418033889183535104, 1418030256765276160, '我的历史流程', '/admin/flow/flowOperation/listHistoricProcessInstance', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418034243434450944, 1418030256765276160, '历史流程数据', '/admin/flow/flowOnlineOperation/viewHistoricProcessInstance', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418035997727264768, 1418030256765276160, '历史流程信息', '/admin/flow/flowOperation/viewInitialHistoricTaskInfo', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418040510253109248, 1418030256765276160, '终止流程', '/admin/flow/flowOperation/stopProcessInstance', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418040574245605376, 1418030256765276160, '删除流程', '/admin/flow/flowOperation/deleteProcessInstance', 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418051334564745216, 1418051228918616064, '仅启动流程', '/admin/flow/flowOperation/startOnly', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418051485324808192, 1418051228918616064, '获取启动信息', '/admin/flow/flowOperation/viewInitialTaskInfo', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418051693639110656, 1418051634793025536, '流程审批', '/admin/flow/flowOperation/viewRuntimeTaskInfo', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418054128097038336, 1418051634793025536, '在办流程数据', '/admin/flow/flowOnlineOperation/viewUserTask', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418054519798894592, 1418054414190514176, '获取流程图', '/admin/flow/flowOperation/viewProcessBpmn', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418054618176294912, 1418054414190514176, '审批历史记录列表', '/admin/flow/flowOperation/listFlowTaskComment', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418054792965525504, 1418054414190514176, '流程审批状态', '/admin/flow/flowOperation/viewHighlightFlowData', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418055060981551104, 1418051634793025536, '提交审批数据', '/admin/flow/flowOnlineOperation/submitUserTask', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418056212146032640, 1418051634793025536, '待办任务列表', '/admin/flow/flowOperation/listRuntimeTask', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418056212146032641, 1418051634793025536, '待办任务数量', '/admin/flow/flowOperation/countRuntimeTask', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418079603167072256, 1418054414190514176, '文件上传', '/admin/flow/flowOnlineOperation/upload', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1418079670594703360, 1418054414190514176, '文件下载', '/admin/flow/flowOnlineOperation/download', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1423635764486344704, 1423635643371622400, '已办任务列表', '/admin/flow/flowOperation/listHistoricTask', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1423635851312631808, 1423635643371622400, '已办任务信息', '/admin/flow/flowOperation/viewHistoricTaskInfo', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1423636091033882624, 1423635643371622400, '加签', '/admin/flow/flowOperation/submitConsign', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1423984506028691456, 1418030256765276160, '撤销工单', '/admin/flow/flowOperation/cancelWorkOrder', 7, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213185, 1440911410581213184, '新增', '/admin/upms/sysDept/add', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213186, 1440911410581213184, '编辑', '/admin/upms/sysDept/update', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213187, 1440911410581213184, '删除', '/admin/upms/sysDept/delete', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213188, 1440911410581213184, '显示列表', '/admin/upms/sysDept/list', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213189, 1440911410581213184, '导出', '/admin/upms/sysDept/export', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213190, 1440911410581213184, '详情', '/admin/upms/sysDept/view', 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213191, 1440911410581213184, '打印', '/admin/upms/sysDept/print', 7, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213192, 1440911410581213184, '新增部门岗位', '/admin/upms/sysDept/addSysDeptPost', 8, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213193, 1440911410581213184, '编辑部门岗位', '/admin/upms/sysDept/updateSysDeptPost', 9, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213194, 1440911410581213184, '移除部门岗位', '/admin/upms/sysDept/deleteSysDeptPost', 10, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213195, 1440911410581213184, '列表显示部门岗位', '/admin/upms/sysDept/listSysDeptPost', 11, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213196, 1440911410581213184, '列表显示未关联部门岗位', '/admin/upms/sysDept/listNotInSysDeptPost', 12, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213197, 1440911410581213184, '详情显示部门岗位', '/admin/upms/sysDept/viewSysDeptPost', 13, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213199, 1440911410581213198, '新增', '/admin/upms/sysUser/add', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213200, 1440911410581213198, '编辑', '/admin/upms/sysUser/update', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213201, 1440911410581213198, '删除', '/admin/upms/sysUser/delete', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213202, 1440911410581213198, '显示列表', '/admin/upms/sysUser/list', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213203, 1440911410581213198, '导出', '/admin/upms/sysUser/export', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213204, 1440911410581213198, '详情', '/admin/upms/sysUser/view', 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213205, 1440911410581213198, '打印', '/admin/upms/sysUser/print', 7, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213206, 1440911410581213198, '重置密码', '/admin/upms/sysUser/resetPassword', 8, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213207, 1440911410581213198, '用户权限资源分配详情', '/admin/upms/sysUser/listSysPermWithDetail', 9, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213208, 1440911410581213198, '用户权限字分配详情', '/admin/upms/sysUser/listSysPermCodeWithDetail', 10, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213209, 1440911410581213198, '用户菜单分配详情', '/admin/upms/sysUser/listSysMenuWithDetail', 11, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213211, 1440911410581213210, '新增', '/admin/upms/sysRole/add', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213212, 1440911410581213210, '编辑', '/admin/upms/sysRole/update', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213213, 1440911410581213210, '删除', '/admin/upms/sysRole/delete', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213214, 1440911410581213210, '显示列表', '/admin/upms/sysRole/list', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213215, 1440911410581213210, '详情', '/admin/upms/sysRole/view', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213216, 1440911410581213210, '授权用户', '/admin/upms/sysRole/addUserRole', 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213217, 1440911410581213210, '移除用户', '/admin/upms/sysRole/deleteUserRole', 7, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213218, 1440911410581213210, '角色用户列表', '/admin/upms/sysRole/listUserRole', 8, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213219, 1440911410581213210, '角色未添加用户列表', '/admin/upms/sysRole/listNotInUserRole', 9, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213220, 1440911410581213210, '角色权限资源分配详情', '/admin/upms/sysRole/listSysPermWithDetail', 10, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213221, 1440911410581213210, '角色权限字分配详情', '/admin/upms/sysRole/listSysPermCodeWithDetail', 11, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213223, 1440911410581213222, '新增', '/admin/upms/sysDataPerm/add', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213224, 1440911410581213222, '编辑', '/admin/upms/sysDataPerm/update', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213225, 1440911410581213222, '删除', '/admin/upms/sysDataPerm/delete', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213226, 1440911410581213222, '显示列表', '/admin/upms/sysDataPerm/list', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213227, 1440911410581213222, '详情', '/admin/upms/sysDataPerm/view', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213228, 1440911410581213222, '授权用户', '/admin/upms/sysDataPerm/addDataPermUser', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213229, 1440911410581213222, '移除用户', '/admin/upms/sysDataPerm/deleteDataPermUser', 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213230, 1440911410581213222, '数据权限用户列表', '/admin/upms/sysDataPerm/listDataPermUser', 7, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213231, 1440911410581213222, '数据权限未添加用户列表', '/admin/upms/sysDataPerm/listNotInDataPermUser', 8, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213233, 1440911410581213232, '新增', '/admin/upms/sysPost/add', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213234, 1440911410581213232, '编辑', '/admin/upms/sysPost/update', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213235, 1440911410581213232, '删除', '/admin/upms/sysPost/delete', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213236, 1440911410581213232, '显示列表', '/admin/upms/sysPost/list', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213237, 1440911410581213232, '详情', '/admin/upms/sysPost/view', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213239, 1440911410581213238, '新增', '/admin/upms/sysMenu/add', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213240, 1440911410581213238, '删除', '/admin/upms/sysMenu/delete', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213241, 1440911410581213238, '编辑', '/admin/upms/sysMenu/update', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213242, 1440911410581213238, '显示列表', '/admin/upms/sysMenu/list', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213243, 1440911410581213238, '详情', '/admin/upms/sysMenu/view', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213244, 1440911410581213238, '菜单权限资源分配详情', '/admin/upms/sysMenu/listSysPermWithDetail', 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213245, 1440911410581213238, '菜单用户分配详情', '/admin/upms/sysMenu/listSysUserWithDetail', 7, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213247, 1440911410581213246, '新增', '/admin/upms/sysPermCode/add', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213248, 1440911410581213246, '编辑', '/admin/upms/sysPermCode/update', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213249, 1440911410581213246, '删除', '/admin/upms/sysPermCode/delete', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213250, 1440911410581213246, '显示列表', '/admin/upms/sysPermCode/list', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213251, 1440911410581213246, '详情', '/admin/upms/sysPermCode/view', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213252, 1440911410581213246, '权限字用户分配详情', '/admin/upms/sysPermCode/listSysUserWithDetail', 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213253, 1440911410581213246, '权限字角色分配详情', '/admin/upms/sysPermCode/listSysRoleWithDetail', 7, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213255, 1440911410581213254, '新增', '/admin/upms/sysPermModule/add', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213256, 1440911410581213254, '编辑', '/admin/upms/sysPermModule/update', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213257, 1440911410581213254, '删除', '/admin/upms/sysPermModule/delete', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213258, 1440911410581213254, '显示列表', '/admin/upms/sysPermModule/list', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213259, 1440911410581213254, '显示全部', '/admin/upms/sysPermModule/listAll', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213261, 1440911410581213260, '新增', '/admin/upms/sysPerm/add', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213262, 1440911410581213260, '编辑', '/admin/upms/sysPerm/update', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213263, 1440911410581213260, '删除', '/admin/upms/sysPerm/delete', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213264, 1440911410581213260, '显示列表', '/admin/upms/sysPerm/list', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213265, 1440911410581213260, '详情', '/admin/upms/sysPerm/view', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213266, 1440911410581213260, '权限资源用户分配详情', '/admin/upms/sysPerm/listSysUserWithDetail', 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213267, 1440911410581213260, '权限资源角色分配详情', '/admin/upms/sysPerm/listSysRoleWithDetail', 7, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213268, 1440911410581213260, '权限资源菜单分配详情', '/admin/upms/sysPerm/listSysMenuWithDetail', 8, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213271, 1440911410581213270, '新增', '/admin/app/areaCode/add', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213272, 1440911410581213270, '编辑', '/admin/app/areaCode/update', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213273, 1440911410581213270, '删除', '/admin/app/areaCode/delete', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213274, 1440911410581213270, '同步缓存', '/admin/app/areaCode/reloadCachedData', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213276, 1440911410581213275, '显示列表', '/admin/upms/loginUser/list', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440911410581213277, 1440911410581213275, '删除', '/admin/upms/loginUser/delete', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm` VALUES (1440975727276068864, 1440975375537541120, '启动并提交数据', '/admin/flow/flowOnlineOperation/startAndTakeUserTask/flowLeave', 1, 1440911410581213417, '管理员', '2021-09-23 17:46:00', 1440911410581213417, '管理员', '2021-09-23 17:46:00', 0);
INSERT INTO `sys_perm` VALUES (1440975781374201856, 1440975375537541120, '工单列表', '/admin/flow/flowOnlineOperation/listWorkOrder/flowLeave', 2, 1440911410581213417, '管理员', '2021-09-23 17:46:13', 1440911410581213417, '管理员', '2021-09-23 17:46:13', 0);
INSERT INTO `sys_perm` VALUES (1440975850529886208, 1440975429199466496, '启动并提交数据', '/admin/flow/flowOnlineOperation/startAndTakeUserTask/flowSubmit', 1, 1440911410581213417, '管理员', '2021-09-23 17:46:29', 1440911410581213417, '管理员', '2021-09-23 17:46:29', 0);
INSERT INTO `sys_perm` VALUES (1440975895627042816, 1440975429199466496, '工单列表', '/admin/flow/flowOnlineOperation/listWorkOrder/flowSubmit', 2, 1440911410581213417, '管理员', '2021-09-23 17:46:40', 1440911410581213417, '管理员', '2021-09-23 17:46:40', 0);
INSERT INTO `sys_perm` VALUES (1440975979374710784, 1440975469133434880, '启动并提交数据', '/admin/flow/flowOnlineOperation/startAndTakeUserTask/flowContract', 1, 1440911410581213417, '管理员', '2021-09-23 17:47:00', 1440911410581213417, '管理员', '2021-09-23 17:47:00', 0);
INSERT INTO `sys_perm` VALUES (1440976024471867392, 1440975469133434880, '工单列表', '/admin/flow/flowOnlineOperation/listWorkOrder/flowContract', 2, 1440911410581213417, '管理员', '2021-09-23 17:47:11', 1440911410581213417, '管理员', '2021-09-23 17:47:11', 0);
INSERT INTO `sys_perm` VALUES (1440976144311521280, 1440975527128076288, '启动并提交数据', '/admin/flow/flowOnlineOperation/startAndTakeUserTask/flowConSign', 1, 1440911410581213417, '管理员', '2021-09-23 17:47:40', 1440911410581213417, '管理员', '2021-09-23 17:47:40', 0);
INSERT INTO `sys_perm` VALUES (1440976188553039872, 1440975527128076288, '工单列表', '/admin/flow/flowOnlineOperation/listWorkOrder/flowConSign', 2, 1440911410581213417, '管理员', '2021-09-23 17:47:50', 1440911410581213417, '管理员', '2021-09-23 17:47:50', 0);
INSERT INTO `sys_perm` VALUES (1440976259415805952, 1440975571776442368, '启动并提交数据', '/admin/flow/flowOnlineOperation/startAndTakeUserTask/flowTranslate', 1, 1440911410581213417, '管理员', '2021-09-23 17:48:07', 1440911410581213417, '管理员', '2021-09-23 17:48:07', 0);
INSERT INTO `sys_perm` VALUES (1440976310951219200, 1440975571776442368, '工单列表', '/admin/flow/flowOnlineOperation/listWorkOrder/flowTranslate', 2, 1440911410581213417, '管理员', '2021-09-23 17:48:19', 1440911410581213417, '管理员', '2021-09-23 17:48:19', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_perm_code_perm
-- ----------------------------
DROP TABLE IF EXISTS `sys_perm_code_perm`;
CREATE TABLE `sys_perm_code_perm` (
  `perm_code_id` bigint(20) unsigned NOT NULL COMMENT '权限字Id',
  `perm_id` bigint(20) unsigned NOT NULL COMMENT '权限id',
  PRIMARY KEY (`perm_code_id`,`perm_id`),
  KEY `idx_perm_id` (`perm_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='系统权限字和权限资源关联表';

-- ----------------------------
-- Records of sys_perm_code_perm
-- ----------------------------
BEGIN;
INSERT INTO `sys_perm_code_perm` VALUES (1400638885750378496, 1400626748101496832);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400626748101496832);
INSERT INTO `sys_perm_code_perm` VALUES (1400638885750378496, 1400626963806162944);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400626963806162944);
INSERT INTO `sys_perm_code_perm` VALUES (1400638885750378496, 1400627109692444672);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400627109692444672);
INSERT INTO `sys_perm_code_perm` VALUES (1400638885750378496, 1400632108514283520);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400632108514283520);
INSERT INTO `sys_perm_code_perm` VALUES (1400638885750378496, 1400632216169484288);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400632216169484288);
INSERT INTO `sys_perm_code_perm` VALUES (1400638885750378496, 1400632326538399744);
INSERT INTO `sys_perm_code_perm` VALUES (1400638885750378496, 1400632438635368448);
INSERT INTO `sys_perm_code_perm` VALUES (1400638885750378496, 1400632511620452352);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400632924021198848);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400632978937221120);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400633026181861376);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400633077717274624);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400633129688895488);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400633375525441536);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1400633375525441536);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400633437093629952);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400633529678696448);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400633568027217920);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400633612201627648);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400633713376628736);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400633798403559424);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400633922085195776);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400634012745076736);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400634100498305024);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400634280308117504);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400634354593435648);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400634559896227840);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400634613151305728);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400634651944423424);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400634693472227328);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400634735549485056);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400635131969933312);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1400635131969933312);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400635267726970880);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400635341274091520);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400635378506928128);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400635426808532992);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400635527698321408);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400635581532213248);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400635661106548736);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1400635661106548736);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400635757332271104);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400635827347787776);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400635896461529088);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400635963469729792);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400636031752998912);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400636182936686592);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400636217728438272);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400636258107002880);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400636301480300544);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400636338838966272);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400636501900922880);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1400636501900922880);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400636535371468800);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400636571165659136);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400636610403373056);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400636656679129088);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400637740705386496);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1400637740705386496);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400637775962705920);
INSERT INTO `sys_perm_code_perm` VALUES (1423637544578322432, 1400637775962705920);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1400637775962705920);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1400637775962705920);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400637822737584128);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400637858414333952);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400637895328403456);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1400637970863624192);
INSERT INTO `sys_perm_code_perm` VALUES (1418050322282057728, 1400637970863624192);
INSERT INTO `sys_perm_code_perm` VALUES (1418050797706416128, 1400637970863624192);
INSERT INTO `sys_perm_code_perm` VALUES (1418057346877231104, 1400637970863624192);
INSERT INTO `sys_perm_code_perm` VALUES (1423637544578322432, 1400637970863624192);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1400637970863624192);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1400637970863624192);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1413405061278601216);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1413405061278601216);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1413405166471745536);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1413405224021790720);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1413405313788284928);
INSERT INTO `sys_perm_code_perm` VALUES (1400639252747784192, 1413405352866615296);
INSERT INTO `sys_perm_code_perm` VALUES (1418050322282057728, 1418026612762349572);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418026612762349580);
INSERT INTO `sys_perm_code_perm` VALUES (1418046848794365952, 1418030338508066816);
INSERT INTO `sys_perm_code_perm` VALUES (1418046986677915648, 1418030386436378624);
INSERT INTO `sys_perm_code_perm` VALUES (1418047095188754432, 1418030437971791872);
INSERT INTO `sys_perm_code_perm` VALUES (1418047182946177024, 1418030477918343168);
INSERT INTO `sys_perm_code_perm` VALUES (1418047095188754432, 1418030533757112320);
INSERT INTO `sys_perm_code_perm` VALUES (1418048205177753600, 1418031006660694016);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418031078391681024);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418031120481521664);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418031174604820480);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418031219706171392);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418031304779239424);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418031515207471104);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418031648351457280);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418031712788549632);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418031801271586816);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418032222232907776);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418032258429751296);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418032300414734336);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418032344064856064);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418032382409183232);
INSERT INTO `sys_perm_code_perm` VALUES (1418049164754817024, 1418033804987076608);
INSERT INTO `sys_perm_code_perm` VALUES (1418057346877231104, 1418033889183535104);
INSERT INTO `sys_perm_code_perm` VALUES (1418049164754817024, 1418034243434450944);
INSERT INTO `sys_perm_code_perm` VALUES (1418057346877231104, 1418034243434450944);
INSERT INTO `sys_perm_code_perm` VALUES (1423637544578322432, 1418034243434450944);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1418034243434450944);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1418034243434450944);
INSERT INTO `sys_perm_code_perm` VALUES (1418049164754817024, 1418035997727264768);
INSERT INTO `sys_perm_code_perm` VALUES (1418057346877231104, 1418035997727264768);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1418035997727264768);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1418035997727264768);
INSERT INTO `sys_perm_code_perm` VALUES (1418049287106859008, 1418040510253109248);
INSERT INTO `sys_perm_code_perm` VALUES (1418049398776008704, 1418040574245605376);
INSERT INTO `sys_perm_code_perm` VALUES (1418050797706416128, 1418051334564745216);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1418051334564745216);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1418051334564745216);
INSERT INTO `sys_perm_code_perm` VALUES (1418050797706416128, 1418051485324808192);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1418051485324808192);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1418051485324808192);
INSERT INTO `sys_perm_code_perm` VALUES (1418050322282057728, 1418051693639110656);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1418051693639110656);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1418051693639110656);
INSERT INTO `sys_perm_code_perm` VALUES (1418050322282057728, 1418054128097038336);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1418054128097038336);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1418054128097038336);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1418054519798894592);
INSERT INTO `sys_perm_code_perm` VALUES (1418049164754817024, 1418054519798894592);
INSERT INTO `sys_perm_code_perm` VALUES (1418050322282057728, 1418054519798894592);
INSERT INTO `sys_perm_code_perm` VALUES (1418050797706416128, 1418054519798894592);
INSERT INTO `sys_perm_code_perm` VALUES (1418057346877231104, 1418054519798894592);
INSERT INTO `sys_perm_code_perm` VALUES (1423637544578322432, 1418054519798894592);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1418054519798894592);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1418054519798894592);
INSERT INTO `sys_perm_code_perm` VALUES (1418050322282057728, 1418054618176294912);
INSERT INTO `sys_perm_code_perm` VALUES (1418057346877231104, 1418054618176294912);
INSERT INTO `sys_perm_code_perm` VALUES (1423637544578322432, 1418054618176294912);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1418054618176294912);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1418054618176294912);
INSERT INTO `sys_perm_code_perm` VALUES (1418049164754817024, 1418054792965525504);
INSERT INTO `sys_perm_code_perm` VALUES (1418050322282057728, 1418054792965525504);
INSERT INTO `sys_perm_code_perm` VALUES (1418057346877231104, 1418054792965525504);
INSERT INTO `sys_perm_code_perm` VALUES (1423637544578322432, 1418054792965525504);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1418054792965525504);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1418054792965525504);
INSERT INTO `sys_perm_code_perm` VALUES (1418050322282057728, 1418055060981551104);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1418055060981551104);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1418055060981551104);
INSERT INTO `sys_perm_code_perm` VALUES (1418050322282057728, 1418056212146032640);
INSERT INTO `sys_perm_code_perm` VALUES (1418050322282057728, 1418079603167072256);
INSERT INTO `sys_perm_code_perm` VALUES (1418050797706416128, 1418079603167072256);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1418079603167072256);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1418079603167072256);
INSERT INTO `sys_perm_code_perm` VALUES (1418050322282057728, 1418079670594703360);
INSERT INTO `sys_perm_code_perm` VALUES (1418050797706416128, 1418079670594703360);
INSERT INTO `sys_perm_code_perm` VALUES (1418057346877231104, 1418079670594703360);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1418079670594703360);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1418079670594703360);
INSERT INTO `sys_perm_code_perm` VALUES (1423637544578322432, 1423635764486344704);
INSERT INTO `sys_perm_code_perm` VALUES (1423637544578322432, 1423635851312631808);
INSERT INTO `sys_perm_code_perm` VALUES (1423637544578322432, 1423636091033882624);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1423636091033882624);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1423636091033882624);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1423984506028691456);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1423984506028691456);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213302, 1440911410581213185);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213303, 1440911410581213186);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213304, 1440911410581213187);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213288, 1440911410581213188);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213289, 1440911410581213188);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213301, 1440911410581213188);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213301, 1440911410581213189);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213303, 1440911410581213190);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213303, 1440911410581213191);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213305, 1440911410581213192);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213305, 1440911410581213193);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213305, 1440911410581213194);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213305, 1440911410581213195);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213306, 1440911410581213195);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213305, 1440911410581213196);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213305, 1440911410581213197);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213306, 1440911410581213197);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213288, 1440911410581213199);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213289, 1440911410581213200);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213290, 1440911410581213201);
INSERT INTO `sys_perm_code_perm` VALUES (1418048335343783936, 1440911410581213202);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213287, 1440911410581213202);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213287, 1440911410581213203);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213289, 1440911410581213204);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213289, 1440911410581213205);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213291, 1440911410581213206);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213292, 1440911410581213207);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213292, 1440911410581213208);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213292, 1440911410581213209);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213321, 1440911410581213211);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213322, 1440911410581213212);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213323, 1440911410581213213);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213288, 1440911410581213214);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213289, 1440911410581213214);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213319, 1440911410581213214);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213322, 1440911410581213215);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213325, 1440911410581213216);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213326, 1440911410581213217);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213320, 1440911410581213218);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213325, 1440911410581213219);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213324, 1440911410581213220);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213324, 1440911410581213221);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213340, 1440911410581213223);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213341, 1440911410581213224);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213342, 1440911410581213225);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213288, 1440911410581213226);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213289, 1440911410581213226);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213338, 1440911410581213226);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213341, 1440911410581213227);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213343, 1440911410581213228);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213344, 1440911410581213229);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213339, 1440911410581213230);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213343, 1440911410581213231);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213413, 1440911410581213233);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213414, 1440911410581213234);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213415, 1440911410581213235);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213412, 1440911410581213236);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213414, 1440911410581213237);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213353, 1440911410581213239);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213355, 1440911410581213240);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213354, 1440911410581213241);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213321, 1440911410581213242);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213322, 1440911410581213242);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213352, 1440911410581213242);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213354, 1440911410581213243);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213356, 1440911410581213244);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213356, 1440911410581213245);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213365, 1440911410581213247);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213366, 1440911410581213248);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213367, 1440911410581213249);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213353, 1440911410581213250);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213354, 1440911410581213250);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213364, 1440911410581213250);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213366, 1440911410581213251);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213368, 1440911410581213252);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213368, 1440911410581213253);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213380, 1440911410581213255);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213381, 1440911410581213256);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213382, 1440911410581213257);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213379, 1440911410581213258);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213365, 1440911410581213259);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213366, 1440911410581213259);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213379, 1440911410581213259);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213383, 1440911410581213261);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213384, 1440911410581213262);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213385, 1440911410581213263);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213379, 1440911410581213264);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213384, 1440911410581213265);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213386, 1440911410581213266);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213386, 1440911410581213267);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213386, 1440911410581213268);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213394, 1440911410581213271);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213394, 1440911410581213272);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213394, 1440911410581213273);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213394, 1440911410581213274);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213403, 1440911410581213276);
INSERT INTO `sys_perm_code_perm` VALUES (1440911410581213404, 1440911410581213277);
INSERT INTO `sys_perm_code_perm` VALUES (1418050797706416128, 1440975727276068864);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1440975727276068864);
INSERT INTO `sys_perm_code_perm` VALUES (1440977405874278400, 1440975781374201856);
INSERT INTO `sys_perm_code_perm` VALUES (1418050797706416128, 1440975850529886208);
INSERT INTO `sys_perm_code_perm` VALUES (1418050797706416128, 1440975979374710784);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1440975979374710784);
INSERT INTO `sys_perm_code_perm` VALUES (1440977767599443968, 1440976024471867392);
INSERT INTO `sys_perm_code_perm` VALUES (1418050797706416128, 1440976144311521280);
INSERT INTO `sys_perm_code_perm` VALUES (1418050797706416128, 1440976259415805952);
COMMIT;

-- ----------------------------
-- Table structure for sys_perm_code
-- ----------------------------
DROP TABLE IF EXISTS `sys_perm_code`;
CREATE TABLE `sys_perm_code` (
  `perm_code_id` bigint(20) unsigned NOT NULL COMMENT '主键Id',
  `parent_id` bigint(20) unsigned DEFAULT NULL COMMENT '上级权限字Id',
  `perm_code` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '权限字标识(一般为有含义的英文字符串)',
  `perm_code_type` int(11) NOT NULL COMMENT '类型(0: 表单 1: UI片段 2: 操作)',
  `show_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '显示名称',
  `show_order` int(11) NOT NULL COMMENT '显示顺序(数值越小，越靠前)',
  `create_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '创建者Id',
  `create_user_name` varchar(32) DEFAULT NULL COMMENT '创建者显示名称',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '更新者Id',
  `update_user_name` varchar(32) DEFAULT NULL COMMENT '更新者显示名称',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  `deleted_flag` int(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除标记(0: 正常 1: 已删除)',
  PRIMARY KEY (`perm_code_id`),
  UNIQUE KEY `idx_perm_code` (`perm_code`) USING BTREE,
  KEY `idx_parent_id` (`parent_id`) USING BTREE,
  KEY `idx_show_order` (`show_order`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='系统权限资源表';

-- ----------------------------
-- Records of sys_perm_code
-- ----------------------------
BEGIN;
INSERT INTO `sys_perm_code` VALUES (1400638673195634688, NULL, 'formOnlineDict', 0, '在线表单字典管理', 12000, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1400638885750378496, 1400638673195634688, 'formOnlineDict:fragmentOnlineDict', 1, '在线表单字典管理', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1400639030462255104, NULL, 'formOnlinePage', 0, '在线表单表单管理', 12100, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1400639252747784192, 1400639030462255104, 'formOnlinePage:fragmentOnlinePage', 1, '在线表单表单管理', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418046729906819072, NULL, 'formFlowCategory', 0, '流程分类', 13000, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418046848794365952, 1418046729906819072, 'formFlowCategory:formFlowCategory', 1, '流程分类', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418046986677915648, 1418046848794365952, 'formFlowCategory:formFlowCategory:add', 2, '新增', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418047095188754432, 1418046848794365952, 'formFlowCategory:formFlowCategory:update', 2, '编辑', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418047182946177024, 1418046848794365952, 'formFlowCategory:formFlowCategory:delete', 2, '删除', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418048134759583744, NULL, 'formFlowEntry', 0, '流程设计', 13100, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418048205177753600, 1418048134759583744, 'formFlowEntry:formFlowEntry', 1, '流程设计', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418048335343783936, 1418048205177753600, 'formFlowEntry:formFlowEntry:update', 2, '编辑', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418048872671875072, NULL, 'formAllInstance', 0, '流程实例', 13200, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418049164754817024, 1418048872671875072, 'formAllInstance:formAllInstance', 1, '流程实例', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418049287106859008, 1418049164754817024, 'formAllInstance:formAllInstance:stop', 2, '终止', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418049398776008704, 1418049164754817024, 'formAllInstance:formAllInstance:delete', 2, '删除', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418050031436435456, NULL, 'formMyTask', 0, '我的待办', 13300, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418050322282057728, 1418050031436435456, 'formMyTask:formMyTask', 1, '我的待办', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418050797706416128, 1418048205177753600, 'formFlowEntry:formFlowEntry:start', 2, '启动', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-24 09:28:39', 0);
INSERT INTO `sys_perm_code` VALUES (1418057020824621056, NULL, 'formMyHistoryTask', 0, '历史流程', 13400, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1418057346877231104, 1418057020824621056, 'formMyHistoryTask:formMyHistoryTask', 1, '历史流程', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1423636498195943424, NULL, 'formMyApprovedTask', 0, '已办任务', 13500, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1423637544578322432, 1423636498195943424, 'formMyApprovedTask:formMyApprovedTask', 1, '已办任务', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213286, NULL, 'formSysUser', 0, '用户管理', 10000, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213287, 1440911410581213286, 'formSysUser:fragmentSysUser', 1, '用户管理', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213288, 1440911410581213287, 'formSysUser:fragmentSysUser:add', 2, '新增', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213289, 1440911410581213287, 'formSysUser:fragmentSysUser:update', 2, '编辑', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213290, 1440911410581213287, 'formSysUser:fragmentSysUser:delete', 2, '删除', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213291, 1440911410581213287, 'formSysUser:fragmentSysUser:resetPassword', 2, '重置密码', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213292, 1440911410581213287, 'formSysUser:fragmentSysUser:listSysUserPermDetail', 2, '权限详情', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213300, NULL, 'formSysDept', 0, '部门管理', 10100, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213301, 1440911410581213300, 'formSysDept:fragmentSysDept', 1, '部门管理', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213302, 1440911410581213301, 'formSysDept:fragmentSysDept:add', 2, '新增', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213303, 1440911410581213301, 'formSysDept:fragmentSysDept:update', 2, '编辑', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213304, 1440911410581213301, 'formSysDept:fragmentSysDept:delete', 2, '删除', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213305, 1440911410581213301, 'formSysDept:fragmentSysDept:editPost', 2, '设置岗位', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213306, 1440911410581213301, 'formSysDept:fragmentSysDept:viewPost', 2, '查看岗位', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213318, NULL, 'formSysRole', 0, '角色管理', 10200, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213319, 1440911410581213318, 'formSysRole:fragmentSysRole', 1, '角色管理', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213320, 1440911410581213318, 'formSysRole:fragmentSysRoleUser', 1, '用户授权', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213321, 1440911410581213319, 'formSysRole:fragmentSysRole:add', 2, '新增', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213322, 1440911410581213319, 'formSysRole:fragmentSysRole:update', 2, '编辑', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213323, 1440911410581213319, 'formSysRole:fragmentSysRole:delete', 2, '删除', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213324, 1440911410581213319, 'formSysRole:fragmentSysRole:listSysRolePermDetail', 2, '权限详情', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213325, 1440911410581213320, 'formSysRole:fragmentSysRoleUser:addUserRole', 2, '授权用户', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213326, 1440911410581213320, 'formSysRole:fragmentSysRoleUser:deleteUserRole', 2, '移除用户', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213337, NULL, 'formSysDataPerm', 0, '数据权限管理', 10400, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213338, 1440911410581213337, 'formSysDataPerm:fragmentSysDataPerm', 1, '数据权限管理', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213339, 1440911410581213337, 'formSysDataPerm:fragmentSysDataPermUser', 1, '用户授权', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213340, 1440911410581213338, 'formSysDataPerm:fragmentSysDataPerm:add', 2, '新增', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213341, 1440911410581213338, 'formSysDataPerm:fragmentSysDataPerm:update', 2, '编辑', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213342, 1440911410581213338, 'formSysDataPerm:fragmentSysDataPerm:delete', 2, '删除', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213343, 1440911410581213339, 'formSysDataPerm:fragmentSysDataPermUser:addDataPermUser', 2, '授权用户', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213344, 1440911410581213339, 'formSysDataPerm:fragmentSysDataPermUser:deleteDataPermUser', 2, '移除用户', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213351, NULL, 'formSysMenu', 0, '菜单管理', 10600, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213352, 1440911410581213351, 'formSysMenu:fragmentSysMenu', 1, '菜单管理', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213353, 1440911410581213352, 'formSysMenu:fragmentSysMenu:add', 2, '新增', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213354, 1440911410581213352, 'formSysMenu:fragmentSysMenu:update', 2, '编辑', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213355, 1440911410581213352, 'formSysMenu:fragmentSysMenu:delete', 2, '删除', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213356, 1440911410581213352, 'formSysMenu:fragmentSysMenu:listSysMenuPermDetail', 2, '权限详情', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213363, NULL, 'formSysPermCode', 0, '权限字管理', 10700, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213364, 1440911410581213363, 'formSysPermCode:fragmentSysPermCode', 1, '权限字管理', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213365, 1440911410581213364, 'formSysPermCode:fragmentSysPermCode:add', 2, '新增', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213366, 1440911410581213364, 'formSysPermCode:fragmentSysPermCode:update', 2, '编辑', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213367, 1440911410581213364, 'formSysPermCode:fragmentSysPermCode:delete', 2, '删除', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213368, 1440911410581213364, 'formSysPermCode:fragmentSysPermCode:listSysPermCodePermDetail', 2, '权限详情', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213378, NULL, 'formSysPerm', 0, '权限管理', 10800, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213379, 1440911410581213378, 'formSysPerm:fragmentSysPerm', 1, '权限管理', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213380, 1440911410581213379, 'formSysPerm:fragmentSysPerm:addPermModule', 2, '新增模块', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213381, 1440911410581213379, 'formSysPerm:fragmentSysPerm:updatePermModule', 2, '编辑模块', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213382, 1440911410581213379, 'formSysPerm:fragmentSysPerm:deletePermModule', 2, '删除模块', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213383, 1440911410581213379, 'formSysPerm:fragmentSysPerm:addPerm', 2, '新增权限', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213384, 1440911410581213379, 'formSysPerm:fragmentSysPerm:updatePerm', 2, '编辑权限', 5, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213385, 1440911410581213379, 'formSysPerm:fragmentSysPerm:deletePerm', 2, '删除权限', 6, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213386, 1440911410581213379, 'formSysPerm:fragmentSysPerm:listSysPermPermDetail', 2, '权限详情', 7, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213393, NULL, 'formSysDict', 0, '字典管理', 10900, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213394, 1440911410581213393, 'formSysDict:fragmentSysDict', 1, '字典管理', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213395, 1440911410581213394, 'formSysDict:fragmentSysDict:add', 2, '新增', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213396, 1440911410581213394, 'formSysDict:fragmentSysDict:update', 2, '编辑', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213397, 1440911410581213394, 'formSysDict:fragmentSysDict:delete', 2, '删除', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213398, 1440911410581213394, 'formSysDict:fragmentSysDict:reloadCache', 2, '同步缓存', 4, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213402, NULL, 'formSysLoginUser', 0, '在线用户', 11200, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213403, 1440911410581213402, 'formSysLoginUser:fragmentLoginUser', 1, '在线用户', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213404, 1440911410581213403, 'formSysLoginUser:fragmentLoginUser:delete', 2, '强制下线', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213411, NULL, 'formSysPost', 0, '岗位管理', 10150, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213412, 1440911410581213411, 'formSysPost:fragmentSysPost', 1, '岗位管理', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213413, 1440911410581213412, 'formSysPost:fragmentSysPost:add', 2, '新增', 1, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213414, 1440911410581213412, 'formSysPost:fragmentSysPost:update', 2, '编辑', 2, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440911410581213415, 1440911410581213412, 'formSysPost:fragmentSysPost:delete', 2, '删除', 3, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_perm_code` VALUES (1440976898661289984, NULL, 'formFlowLeave', 0, '请假申请', 14000, 1440911410581213417, '管理员', '2021-09-23 17:50:39', 1440911410581213417, '管理员', '2021-09-23 17:50:39', 0);
INSERT INTO `sys_perm_code` VALUES (1440976998183735296, NULL, 'formContractOrder', 0, '合同工单', 14100, 1440911410581213417, '管理员', '2021-09-23 17:51:03', 1440911410581213417, '管理员', '2021-09-23 17:51:03', 0);
INSERT INTO `sys_perm_code` VALUES (1440977405874278400, 1440976898661289984, 'formFlowLeave:formFlowLeave', 1, '请假申请', 1, 1440911410581213417, '管理员', '2021-09-23 17:52:40', 1440911410581213417, '管理员', '2021-09-23 17:52:40', 0);
INSERT INTO `sys_perm_code` VALUES (1440977767599443968, 1440976998183735296, 'formContractOrder:formContractOrder', 1, '合同工单', 1, 1440911410581213417, '管理员', '2021-09-23 17:54:07', 1440911410581213417, '管理员', '2021-09-23 17:54:07', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu_perm_code
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu_perm_code`;
CREATE TABLE `sys_menu_perm_code` (
  `menu_id` bigint(20) unsigned NOT NULL COMMENT '关联菜单Id',
  `perm_code_id` bigint(20) unsigned NOT NULL COMMENT '关联权限字Id',
  PRIMARY KEY (`menu_id`,`perm_code_id`) USING BTREE,
  KEY `idx_perm_code_id` (`perm_code_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='菜单和权限关系表';

-- ----------------------------
-- Records of sys_menu_perm_code
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu_perm_code` VALUES (1392786549942259712, 1400638885750378496);
INSERT INTO `sys_menu_perm_code` VALUES (1392786950682841088, 1400639252747784192);
INSERT INTO `sys_menu_perm_code` VALUES (1418057835631087616, 1418046848794365952);
INSERT INTO `sys_menu_perm_code` VALUES (1418058049951633408, 1418046986677915648);
INSERT INTO `sys_menu_perm_code` VALUES (1418058115667988480, 1418047095188754432);
INSERT INTO `sys_menu_perm_code` VALUES (1418058170542067712, 1418047182946177024);
INSERT INTO `sys_menu_perm_code` VALUES (1418058289182150656, 1418048205177753600);
INSERT INTO `sys_menu_perm_code` VALUES (1418058602723151872, 1418048335343783936);
INSERT INTO `sys_menu_perm_code` VALUES (1418058744037642240, 1418049164754817024);
INSERT INTO `sys_menu_perm_code` VALUES (1418058844164067328, 1418049287106859008);
INSERT INTO `sys_menu_perm_code` VALUES (1418058907674218496, 1418049398776008704);
INSERT INTO `sys_menu_perm_code` VALUES (1418059167532322816, 1418050322282057728);
INSERT INTO `sys_menu_perm_code` VALUES (1418058515099947008, 1418050797706416128);
INSERT INTO `sys_menu_perm_code` VALUES (1418059283920064512, 1418057346877231104);
INSERT INTO `sys_menu_perm_code` VALUES (1423161217970606080, 1423636498195943424);
INSERT INTO `sys_menu_perm_code` VALUES (1423161217970606080, 1423637544578322432);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213280, 1440911410581213287);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213281, 1440911410581213288);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213282, 1440911410581213289);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213283, 1440911410581213290);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213284, 1440911410581213291);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213285, 1440911410581213292);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213294, 1440911410581213301);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213295, 1440911410581213302);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213296, 1440911410581213303);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213297, 1440911410581213304);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213298, 1440911410581213305);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213299, 1440911410581213306);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213310, 1440911410581213319);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213315, 1440911410581213320);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213311, 1440911410581213321);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213312, 1440911410581213322);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213313, 1440911410581213323);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213314, 1440911410581213324);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213316, 1440911410581213325);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213317, 1440911410581213326);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213330, 1440911410581213338);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213334, 1440911410581213339);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213331, 1440911410581213340);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213332, 1440911410581213341);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213333, 1440911410581213342);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213335, 1440911410581213343);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213336, 1440911410581213344);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213346, 1440911410581213352);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213347, 1440911410581213353);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213348, 1440911410581213354);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213349, 1440911410581213355);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213350, 1440911410581213356);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213358, 1440911410581213364);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213359, 1440911410581213365);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213360, 1440911410581213366);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213361, 1440911410581213367);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213362, 1440911410581213368);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213370, 1440911410581213379);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213371, 1440911410581213380);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213372, 1440911410581213381);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213373, 1440911410581213382);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213374, 1440911410581213383);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213375, 1440911410581213384);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213376, 1440911410581213385);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213377, 1440911410581213386);
INSERT INTO `sys_menu_perm_code` VALUES (1401532055971434503, 1440911410581213394);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213388, 1440911410581213394);
INSERT INTO `sys_menu_perm_code` VALUES (1401532055971434503, 1440911410581213395);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213389, 1440911410581213395);
INSERT INTO `sys_menu_perm_code` VALUES (1401532055971434503, 1440911410581213396);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213390, 1440911410581213396);
INSERT INTO `sys_menu_perm_code` VALUES (1401532055971434503, 1440911410581213397);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213391, 1440911410581213397);
INSERT INTO `sys_menu_perm_code` VALUES (1401532055971434503, 1440911410581213398);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213392, 1440911410581213398);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213400, 1440911410581213403);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213401, 1440911410581213404);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213407, 1440911410581213412);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213408, 1440911410581213413);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213409, 1440911410581213414);
INSERT INTO `sys_menu_perm_code` VALUES (1440911410581213410, 1440911410581213415);
INSERT INTO `sys_menu_perm_code` VALUES (1440974580402360320, 1440976898661289984);
INSERT INTO `sys_menu_perm_code` VALUES (1440978065088843776, 1440976998183735296);
INSERT INTO `sys_menu_perm_code` VALUES (1440974580402360320, 1440977405874278400);
INSERT INTO `sys_menu_perm_code` VALUES (1440978065088843776, 1440977767599443968);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) unsigned NOT NULL COMMENT '主键Id',
  `parent_id` bigint(20) unsigned DEFAULT NULL COMMENT '父菜单Id，目录菜单的父菜单为null',
  `menu_name` varchar(50) COLLATE utf8mb4_bin NOT NULL COMMENT '菜单显示名称',
  `menu_type` int(11) NOT NULL COMMENT '(0: 目录 1: 菜单 2: 按钮 3: UI片段)',
  `form_router_name` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '前端表单路由名称，仅用于menu_type为1的菜单类型',
  `show_order` int(11) NOT NULL COMMENT '菜单显示顺序 (值越小，排序越靠前)',
  `icon` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '菜单图标',
  `create_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '创建者Id',
  `create_user_name` varchar(32) DEFAULT NULL COMMENT '创建者显示名称',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '更新者Id',
  `update_user_name` varchar(32) DEFAULT NULL COMMENT '更新者显示名称',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  `deleted_flag` int(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除标记(0: 正常 1: 已删除)',
  PRIMARY KEY (`menu_id`) USING BTREE,
  KEY `idx_show_order` (`show_order`) USING BTREE,
  KEY `idx_parent_id` (`parent_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='菜单和操作权限管理表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1392786476428693504, NULL, '在线表单', 0, NULL, 2, 'el-icon-c-scale-to-original', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 17:42:00', 0);
INSERT INTO `sys_menu` VALUES (1392786549942259712, 1392786476428693504, '字典管理', 1, 'formOnlineDict', 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1392786950682841088, 1392786476428693504, '表单管理', 1, 'formOnlinePage', 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1401532054578925568, NULL, '系统管理', 0, NULL, 1, 'el-icon-setting', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 17:41:39', 0);
INSERT INTO `sys_menu` VALUES (1401532055971434496, 1401532054578925568, '用户管理', 1, 'formSysUser', 100, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1401532055971434497, 1401532054578925568, '部门管理', 1, 'formSysDept', 105, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1401532055971434498, 1401532054578925568, '角色管理', 1, 'formSysRole', 110, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1401532055971434499, 1401532054578925568, '数据权限管理', 1, 'formSysDataPerm', 115, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1401532055971434500, 1401532054578925568, '菜单管理', 1, 'formSysMenu', 120, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1401532055971434501, 1401532054578925568, '权限字管理', 1, 'formSysPermCode', 125, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1401532055971434502, 1401532054578925568, '权限管理', 1, 'formSysPerm', 130, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1401532055971434503, 1401532054578925568, '字典管理', 1, 'formSysDict', 135, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1401532055971434504, 1401532054578925568, '在线用户', 1, 'formSysLoginUser', 145, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1418057714138877952, NULL, '流程管理', 0, NULL, 3, 'el-icon-s-operation', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 17:42:12', 0);
INSERT INTO `sys_menu` VALUES (1418057835631087616, 1418057714138877952, '流程分类', 1, 'formFlowCategory', 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1418058049951633408, 1418057835631087616, '新建', 3, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1418058115667988480, 1418057835631087616, '编辑', 3, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1418058170542067712, 1418057835631087616, '删除', 3, NULL, 3, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1418058289182150656, 1418057714138877952, '流程设计', 1, 'formFlowEntry', 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1418058515099947008, 1418058289182150656, '启动', 3, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1418058602723151872, 1418058289182150656, '编辑', 3, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1418058744037642240, 1418057714138877952, '流程实例', 1, 'formAllInstance', 3, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1418058844164067328, 1418058744037642240, '终止', 3, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1418058907674218496, 1418058744037642240, '删除', 3, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1418059005175009280, NULL, '任务管理', 0, NULL, 4, 'el-icon-tickets', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 17:42:32', 0);
INSERT INTO `sys_menu` VALUES (1418059167532322816, 1418059005175009280, '待办任务', 1, 'formMyTask', 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1418059283920064512, 1418059005175009280, '历史任务', 1, 'formMyHistoryTask', 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1423161217970606080, 1418059005175009280, '已办任务', 1, 'formMyApprovedTask', 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1433040549035642880, 1401532054578925568, '岗位管理', 1, 'formSysPost', 106, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213280, 1401532055971434496, '显示', 3, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213281, 1401532055971434496, '新增', 3, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213282, 1401532055971434496, '编辑', 3, NULL, 3, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213283, 1401532055971434496, '删除', 3, NULL, 4, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213284, 1401532055971434496, '重置密码', 3, NULL, 5, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213285, 1401532055971434496, '权限详情', 3, NULL, 6, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213294, 1401532055971434497, '显示', 3, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213295, 1401532055971434497, '新增', 3, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213296, 1401532055971434497, '编辑', 3, NULL, 3, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213297, 1401532055971434497, '删除', 3, NULL, 4, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213298, 1401532055971434497, '设置岗位', 3, NULL, 5, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213299, 1401532055971434497, '查看岗位', 3, NULL, 6, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213308, 1401532055971434498, '角色管理', 2, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213309, 1401532055971434498, '用户授权', 2, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213310, 1440911410581213308, '显示', 3, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213311, 1440911410581213308, '新增', 3, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213312, 1440911410581213308, '编辑', 3, NULL, 3, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213313, 1440911410581213308, '删除', 3, NULL, 4, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213314, 1440911410581213308, '权限详情', 3, NULL, 5, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213315, 1440911410581213309, '显示', 3, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213316, 1440911410581213309, '授权用户', 3, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213317, 1440911410581213309, '移除用户', 3, NULL, 3, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213328, 1401532055971434499, '数据权限管理', 2, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213329, 1401532055971434499, '用户授权', 2, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213330, 1440911410581213328, '显示', 3, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213331, 1440911410581213328, '新增', 3, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213332, 1440911410581213328, '编辑', 3, NULL, 3, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213333, 1440911410581213328, '删除', 3, NULL, 4, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213334, 1440911410581213329, '显示', 3, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213335, 1440911410581213329, '授权用户', 3, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213336, 1440911410581213329, '移除用户', 3, NULL, 3, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213346, 1401532055971434500, '显示', 3, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213347, 1401532055971434500, '新增', 3, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213348, 1401532055971434500, '编辑', 3, NULL, 3, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213349, 1401532055971434500, '删除', 3, NULL, 4, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213350, 1401532055971434500, '权限详情', 3, NULL, 5, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213358, 1401532055971434501, '显示', 3, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213359, 1401532055971434501, '新增', 3, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213360, 1401532055971434501, '编辑', 3, NULL, 3, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213361, 1401532055971434501, '删除', 3, NULL, 4, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213362, 1401532055971434501, '权限详情', 3, NULL, 5, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213370, 1401532055971434502, '显示', 3, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213371, 1401532055971434502, '新增模块', 3, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213372, 1401532055971434502, '编辑模块', 3, NULL, 3, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213373, 1401532055971434502, '删除模块', 3, NULL, 4, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213374, 1401532055971434502, '新增权限', 3, NULL, 5, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213375, 1401532055971434502, '编辑权限', 3, NULL, 6, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213376, 1401532055971434502, '删除权限', 3, NULL, 7, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213377, 1401532055971434502, '权限详情', 3, NULL, 8, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213388, 1401532055971434503, '显示', 3, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213389, 1401532055971434503, '新增', 3, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213390, 1401532055971434503, '编辑', 3, NULL, 3, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213391, 1401532055971434503, '删除', 3, NULL, 4, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213392, 1401532055971434503, '同步缓存', 3, NULL, 5, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213400, 1401532055971434504, '显示', 3, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213401, 1401532055971434504, '强制下线', 3, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213406, 1433040549035642880, '岗位管理', 2, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213407, 1440911410581213406, '显示', 3, NULL, 1, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213408, 1440911410581213406, '新增', 3, NULL, 2, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213409, 1440911410581213406, '编辑', 3, NULL, 3, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440911410581213410, 1440911410581213406, '删除', 3, NULL, 4, NULL, 1440911410581213417, '管理员', '2021-09-23 00:00:00', 1440911410581213417, '管理员', '2021-09-23 00:00:00', 0);
INSERT INTO `sys_menu` VALUES (1440973980537196544, NULL, '业务管理', 0, NULL, 5, 'el-icon-goods', 1440911410581213417, '管理员', '2021-09-23 17:39:04', 1440911410581213417, '管理员', '2021-09-23 17:42:45', 0);
INSERT INTO `sys_menu` VALUES (1440974310754750464, NULL, '工单管理', 0, NULL, 6, 'el-icon-menu', 1440911410581213417, '管理员', '2021-09-23 17:40:22', 1440911410581213417, '管理员', '2021-09-23 17:43:00', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` bigint(20) unsigned NOT NULL COMMENT '角色Id',
  `menu_id` bigint(20) unsigned NOT NULL COMMENT '菜单Id',
  PRIMARY KEY (`role_id`,`menu_id`) USING BTREE,
  KEY `idx_menu_id` (`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='角色与菜单对应关系表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1392786476428693504);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1392786549942259712);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1392786950682841088);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1401532054578925568);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1401532055971434496);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1401532055971434497);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1401532055971434498);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1401532055971434499);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1401532055971434500);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1401532055971434501);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1401532055971434502);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1401532055971434503);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1401532055971434504);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1418057714138877952);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1418057835631087616);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1418058049951633408);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1418058115667988480);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1418058170542067712);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1418058289182150656);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1418058515099947008);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1418058602723151872);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1418058744037642240);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1418058844164067328);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1418058907674218496);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1418059005175009280);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1418059167532322816);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1418059283920064512);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1423161217970606080);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1433040549035642880);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213280);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213281);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213282);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213283);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213284);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213285);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213294);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213295);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213296);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213297);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213298);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213299);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213308);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213309);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213310);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213311);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213312);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213313);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213314);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213315);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213316);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213317);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213328);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213329);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213330);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213331);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213332);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213333);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213334);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213335);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213336);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213346);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213347);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213348);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213349);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213350);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213358);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213359);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213360);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213361);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213362);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213370);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213371);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213372);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213373);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213374);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213375);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213376);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213377);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213388);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213389);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213390);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213391);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213392);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213400);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213401);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213406);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213407);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213408);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213409);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440911410581213410);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440973980537196544);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440974056105971712);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440974056110166016);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440974056114360320);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440974134195523584);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440974134199717888);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440974134203912192);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440974233613111296);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440974233617305600);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440974233621499904);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440974310754750464);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440974580402360320);
INSERT INTO `sys_role_menu` VALUES (1440965195903012864, 1440978065088843776);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) unsigned NOT NULL COMMENT '主键Id',
  `role_name` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '角色名称',
  `create_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '创建者Id',
  `create_user_name` varchar(32) DEFAULT NULL COMMENT '创建者显示名称',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '更新者Id',
  `update_user_name` varchar(32) DEFAULT NULL COMMENT '更新者显示名称',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  `deleted_flag` int(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除标记(0: 正常 1: 已删除)',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='系统角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1440965195903012864, '查看全部', 1440911410581213417, '管理员', '2021-09-23 17:04:09', 1440911410581213417, '管理员', '2021-09-24 09:25:49', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `user_id` bigint(20) unsigned NOT NULL COMMENT '用户Id',
  `role_id` bigint(20) unsigned NOT NULL COMMENT '角色Id',
  PRIMARY KEY (`user_id`,`role_id`) USING BTREE,
  KEY `idx_role_id` (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='用户与角色对应关系表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (1440965344985354240, 1440965195903012864);
INSERT INTO `sys_user_role` VALUES (1440965465605148672, 1440965195903012864);
INSERT INTO `sys_user_role` VALUES (1440965586715676672, 1440965195903012864);
INSERT INTO `sys_user_role` VALUES (1440965697961201664, 1440965195903012864);
INSERT INTO `sys_user_role` VALUES (1440965808049098752, 1440965195903012864);
INSERT INTO `sys_user_role` VALUES (1440966073686953984, 1440965195903012864);
INSERT INTO `sys_user_role` VALUES (1440966186522120192, 1440965195903012864);
INSERT INTO `sys_user_role` VALUES (1440966324770574336, 1440965195903012864);
INSERT INTO `sys_user_role` VALUES (1440969706411397120, 1440965195903012864);
COMMIT;

-- ----------------------------
-- Table structure for sys_perm_whitelist
-- ----------------------------
DROP TABLE IF EXISTS `sys_perm_whitelist`;
CREATE TABLE `sys_perm_whitelist` (
  `perm_url` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '权限资源的url',
  `module_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '权限资源所属模块名字(通常是Controller的名字)',
  `perm_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '权限的名称',
  PRIMARY KEY (`perm_url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='权限资源白名单表(认证用户均可访问的url资源)';

-- ----------------------------
-- Records of sys_perm_whitelist
-- ----------------------------
BEGIN;
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/app/areaCode/listAll', '行政区划', '字典全部列表');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/app/areaCode/listDict', '行政区划', '行政区划列表');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/app/areaCode/listDictByIds', '行政区划', '行政区划批量Id列表');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/app/areaCode/listDictByParentId', '行政区划', '行政区划过滤列表');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/flow/flowCategory/listDict', '流程管理', '流程分类字典');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/flow/flowEntry/listDict', '流程管理', '流程字典');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/flow/flowEntry/viewDict', '流程管理', '流程部分数据查看');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/flow/flowOnlineOperation/listFlowEntryForm', '流程管理', '流程列表包含在线表单列表');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/flow/flowOperation/countRuntimeTask', '流程管理', '待办任务列表');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/online/onlineOperation/listDict', '在线表单', '在线表单字典');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/upms/login/doLogout', '登录模块', '退出登陆');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/upms/login/getLoginInfo', '登录模块', '获取登录信息');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/upms/sysDept/listDict', '部门管理', '部门字典字典列表');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/upms/sysDept/listDictByIds', '部门管理', '部门字典字典批量Id列表');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/upms/sysDept/listDictByParentId', '部门管理', '部门字典下一级字典列表');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/upms/sysDept/listSysDeptPostWithRelation', '系统管理', '部门岗位关联列表');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/upms/sysPost/listDict', '系统管理', '岗位字典接口');
INSERT INTO `sys_perm_whitelist` VALUES ('/admin/upms/sysPost/listDictByIds', '系统管理', '岗位字典接口');
COMMIT;



-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict`  (
  `id` bigint(20) unsigned NOT NULL COMMENT '字典id',
  `dict_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典名称',
  `dict_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典编码',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `type` int(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT '字典类型(0: string,1: number,2: boolean)',
  `create_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '创建者Id',
  `create_user_name` varchar(32) DEFAULT NULL COMMENT '创建者显示名称',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '更新者Id',
  `update_user_name` varchar(32) DEFAULT NULL COMMENT '更新者显示名称',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  `deleted_flag` int(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除标记(0: 正常 1: 已删除)',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_sd_dict_code`(`dict_code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic COMMENT='字典表';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
INSERT INTO `sys_dict` VALUES (1174511106570525185, '通告类型', 'msg_category', '消息类型1:通知公告2:系统消息', 0, 1440911410581213417, '管理员', '2019-04-22 18:01:35', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1174509082208395266, '职务职级', 'position_rank', '职务表职级字典', 0, 1440911410581213417, '管理员', '2019-09-19 10:22:41', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1174511106530525185, '机构类型', 'org_category', '机构类型 1公司，2部门 3岗位', 0, 1440911410581213417, '管理员', '2019-09-19 10:30:43', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1178295274528845826, '表单权限策略', 'form_perms_type', '', 0, 1440911410581213417, '管理员', '2019-09-29 21:07:39', 1440911410581213417, '管理员', '2019-09-29 21:08:26', 0);
INSERT INTO `sys_dict` VALUES (1199517671259906049, '紧急程度', 'urgent_level', '日程计划紧急程度', 0, 1440911410581213417, '管理员', '2019-11-27 10:37:53', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1199518099888414722, '日程计划类型', 'eoa_plan_type', '', 0, 1440911410581213417, '管理员', '2019-11-27 10:39:36', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1199520177767587841, '分类栏目类型', 'eoa_cms_menu_type', '', 0, 1440911410581213417, '管理员', '2019-11-27 10:47:51', 1440911410581213417, '管理员', '2019-11-27 10:49:35', 0);
INSERT INTO `sys_dict` VALUES (1199525215290306561, '日程计划状态', 'eoa_plan_status', '', 0, 1440911410581213417, '管理员', '2019-11-27 11:07:52', 1440911410581213417, '管理员', '2019-11-27 11:10:11', 0);
INSERT INTO `sys_dict` VALUES (1209733563293962241, '数据库类型', 'database_type', '', 0, 1440911410581213417, '管理员', '2019-12-25 15:12:12', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1232913193820581889, 'Online表单业务分类', 'ol_form_biz_type', '', 0, 1440911410581213417, '管理员', '2020-02-27 14:19:46', 1440911410581213417, '管理员', '2020-02-27 14:20:23', 0);
INSERT INTO `sys_dict` VALUES (1242298510024429569, '提醒方式', 'remindMode', '', 0, 1440911410581213417, '管理员', '2020-03-24 11:53:40', 1440911410581213417, '管理员', '2020-03-24 12:03:22', 0);
INSERT INTO `sys_dict` VALUES (1250687930947620866, '定时任务状态', 'quartz_status', '', 0, 1440911410581213417, '管理员', '2020-04-16 15:30:14', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1280401766745718786, '租户状态', 'tenant_status', '租户状态', 0, 1440911410581213417, '管理员', '2020-07-07 15:22:25', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1356445645198135298, '开关', 'is_open', '', 0, 1440911410581213417, '管理员', '2021-02-02 11:33:38', 1440911410581213417, '管理员', '2021-02-02 15:28:12', 0);
INSERT INTO `sys_dict` VALUES (1280401556745718786, '同步工作流引擎', 'activiti_sync', '同步工作流引擎', 0, 1440911410581213417, '管理员', '2019-05-15 15:27:33', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1280423556745718786, '权限策略', 'perms_type', '权限策略', 0, 1440911410581213417, '管理员', '2019-04-26 18:26:55', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1283523556745718786, '推送类别', 'msg_type', '', 0, 1440911410581213417, '管理员', '2019-03-17 21:21:32', 1440911410581213417, '管理员', '2019-03-26 19:57:45', 0);
INSERT INTO `sys_dict` VALUES (1283523556245718786, '删除状态', 'del_flag', NULL, 0, 1440911410581213417, '管理员', '2019-01-18 21:46:26', 1440911410581213417, '管理员', '2019-03-30 11:17:11', 0);
INSERT INTO `sys_dict` VALUES (1283523552245718786, '性别', 'sex', NULL, 0, 1440911410581213417, '管理员', '2019-01-04 14:56:32', 1440911410581213417, '管理员', '2019-03-30 11:28:27', 1);
INSERT INTO `sys_dict` VALUES (1283524552245718786, '全局权限策略', 'global_perms_type', '全局权限策略', 0, 1440911410581213417, '管理员', '2019-05-10 17:54:05', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1283524552245158786, 'Online图表展示模板', 'online_graph_display_template', 'Online图表展示模板', 0, 1440911410581213417, '管理员', '2019-04-12 17:28:50', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1283524552582451786, '字典状态', 'dict_item_status', NULL, 0, 1440911410581213417, '管理员', '2020-06-18 23:18:42', 1440911410581213417, '管理员', '2019-03-30 19:33:52', 1);
INSERT INTO `sys_dict` VALUES (1283525652582451786, '优先级', 'priority', '优先级', 0, 1440911410581213417, '管理员', '2019-03-16 17:03:34', 1440911410581213417, '管理员', '2019-04-16 17:39:23', 0);
INSERT INTO `sys_dict` VALUES (1283525652582451556, '条件规则', 'rule_conditions', '', 0, 1440911410581213417, '管理员', '2019-04-01 10:15:03', 1440911410581213417, '管理员', '2019-04-01 10:30:47', 0);
INSERT INTO `sys_dict` VALUES (1283356652582451556, '发送消息类型', 'msgType', NULL, 0, 1440911410581213417, '管理员', '2019-04-11 14:27:09', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1283356652582452256, '有效无效状态', 'valid_status', '有效无效状态', 0, 1440911410581213417, '管理员', '2020-09-26 19:21:14', 1440911410581213417, '管理员', '2019-04-26 19:21:23', 0);
INSERT INTO `sys_dict` VALUES (1283116652582452256, '用户类型', 'user_type', NULL, 0, 1440911410581213417, '管理员', '2019-01-04 14:59:01', 1440911410581213417, '管理员', '2019-03-18 23:28:18', 0);
INSERT INTO `sys_dict` VALUES (1283116699582452256, 'Online表单类型', 'cgform_table_type', '', 0, 1440911410581213417, '管理员', '2019-01-27 10:13:02', 1440911410581213417, '管理员', '2019-03-30 11:37:36', 0);
INSERT INTO `sys_dict` VALUES (1184116699582452256, '流程状态', 'bpm_status', '流程状态', 0, 1440911410581213417, '管理员', '2019-05-09 16:31:52', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1134116694582452256, '日志类型', 'log_type', NULL, 0, 1440911410581213417, '管理员', '2019-03-18 23:22:19', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 1);
INSERT INTO `sys_dict` VALUES (1134116694524452256, '状态', 'status', NULL, 0, 1440911410581213417, '管理员', '2019-03-18 21:45:25', 1440911410581213417, '管理员', '2019-03-18 21:58:25', 0);
INSERT INTO `sys_dict` VALUES (1134466694524452256, '操作类型', 'operate_type', '操作类型', 0, 1440911410581213417, '管理员', '2019-07-22 10:54:29', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1134466694524452295, '发布状态', 'send_status', '发布状态', 0, 1440911410581213417, '管理员', '2019-04-16 17:40:42', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1134376694524452295, '1是0否', 'yn', '', 0, 1440911410581213417, '管理员', '2019-05-22 19:29:29', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1134175994524452295, '消息发送状态', 'msgSendStatus', NULL, 0, 1440911410581213417, '管理员', '2019-04-12 18:18:17', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1132575994524452295, '菜单类型', 'menu_type', NULL, 0, 1440911410581213417, '管理员', '2020-12-18 23:24:32', 1440911410581213417, '管理员', '2019-04-01 15:27:06', 1);
INSERT INTO `sys_dict` VALUES (1115475994524452295, 'onlineT类型', 'ceshi_online', NULL, 0, 1440911410581213417, '管理员', '2019-03-22 16:31:49', 1440911410581213417, '管理员', '2019-03-22 16:34:16', 0);
INSERT INTO `sys_dict` VALUES (1115475994519452295, 'Online图表数据类型', 'online_graph_data_type', 'Online图表数据类型', 0, 1440911410581213417, '管理员', '2019-04-12 17:24:24', 1440911410581213417, '管理员', '2019-04-12 17:24:57', 0);
INSERT INTO `sys_dict` VALUES (1194475994519452295, '部门状态', 'depart_status', NULL, 0, 1440911410581213417, '管理员', '2019-03-18 21:59:51', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1194420994519452295, 'Online图表类型', 'online_graph_type', 'Online图表类型', 0, 1440911410581213417, '管理员', '2019-04-12 17:04:06', 1440911410581213417, '管理员', '2020-03-24 11:53:40', 0);
INSERT INTO `sys_dict` VALUES (1194420994519451895, '流程类型', 'bpm_process_type', NULL, 0, 1440911410581213417, '管理员', '2021-02-22 19:26:54', 1440911410581213417, '管理员', '2019-03-30 18:14:44', 0);
INSERT INTO `sys_dict` VALUES (119442194519451895, '用户状态', 'user_status', NULL, 0, 1440911410581213417, '管理员', '2019-03-18 21:57:25', 1440911410581213417, '管理员', '2019-03-18 23:11:58', 1);


-- ----------------------------
-- Table structure for sys_dict_item
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_item`;
CREATE TABLE `sys_dict_item`  (
  `id` bigint(20) unsigned NOT NULL COMMENT '字典项id',
  `dict_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典code',
  `item_text` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典项文本',
  `item_value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典项值',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `sort_order` int(10) NULL DEFAULT NULL COMMENT '排序',
  `status` int(11) NULL DEFAULT NULL COMMENT '状态（1启用 0不启用）',
  `create_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '创建者Id',
  `create_user_name` varchar(32) DEFAULT NULL COMMENT '创建者显示名称',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user_id` bigint(20) unsigned DEFAULT NULL COMMENT '更新者Id',
  `update_user_name` varchar(32) DEFAULT NULL COMMENT '更新者显示名称',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sdi_dict_code`(`dict_code`) USING BTREE,
  INDEX `idx_sdi_sort_order`(`sort_order`) USING BTREE,
  INDEX `idx_sdi_status`(`status`) USING BTREE,
  INDEX `idx_sdi_dict_val`(`dict_code`, `item_value`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic COMMENT='字典项表';

-- ----------------------------
-- Records of sys_dict_item
-- ----------------------------
INSERT INTO `sys_dict_item` VALUES (1174509081434395266, 'priority', '低', 'L', '低', 3, 1, 1440911410581213417, '管理员', '2019-04-16 17:04:59', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1174509081434391666, 'del_flag', '已删除', '1', NULL, NULL, 1, 1440911410581213417, '管理员', '2025-10-18 21:46:56', 1440911410581213417, '管理员', '2019-03-28 22:23:20');
INSERT INTO `sys_dict_item` VALUES (1174509081419391666, 'online_graph_data_type', 'SQL', 'sql', NULL, 1, 1, 1440911410581213417, '管理员', '2019-04-12 17:26:26', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1174229081419391666, 'msg_type', '指定用户', 'USER', NULL, NULL, 1, 1440911410581213417, '管理员', '2019-03-17 21:22:19', 1440911410581213417, '管理员', '2019-03-17 21:22:28');
INSERT INTO `sys_dict_item` VALUES (1174268981419391666, 'cgform_table_type', '附表', '3', NULL, 3, 1, 1440911410581213417, '管理员', '2019-03-27 10:13:43', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1174268251419391666, 'perms_type', '禁用', '2', '禁用', 2, 1, 1440911410581213417, '管理员', '2021-03-26 18:27:28', 1440911410581213417, '管理员', '2019-04-26 18:39:11');
INSERT INTO `sys_dict_item` VALUES (1174509082234395266, 'org_category', '岗位', '3', '岗位', 1, 1, 1440911410581213417, '管理员', '2019-09-19 10:31:16', 1440911410581213417, '管理员', '2019-04-26 18:39:11');
INSERT INTO `sys_dict_item` VALUES (1174268251219391666, 'position_rank', '员级', '1', '', 1, 1, 1440911410581213417, '管理员', '2019-09-19 10:24:45', 1440911410581213417, '管理员', '2019-09-23 11:46:39');
INSERT INTO `sys_dict_item` VALUES (1174509667297026049, 'position_rank', '助级', '2', '', 2, 1, 1440911410581213417, '管理员', '2019-09-19 10:25:01', 1440911410581213417, '管理员', '2019-09-23 11:46:47');
INSERT INTO `sys_dict_item` VALUES (1174509713568587777, 'position_rank', '中级', '3', '', 3, 1, 1440911410581213417, '管理员', '2019-09-19 10:25:12', 1440911410581213417, '管理员', '2019-09-23 11:46:56');
INSERT INTO `sys_dict_item` VALUES (1174509788361416705, 'position_rank', '副高级', '4', '', 4, 1, 1440911410581213417, '管理员', '2019-09-19 10:25:30', 1440911410581213417, '管理员', '2019-09-23 11:47:06');
INSERT INTO `sys_dict_item` VALUES (1174509835803189250, 'position_rank', '正高级', '5', '', 5, 1, 1440911410581213417, '管理员', '2019-09-19 10:25:41', 1440911410581213417, '管理员', '2019-09-23 11:47:12');
INSERT INTO `sys_dict_item` VALUES (1174511197735665665, 'org_category', '公司', '1', '公司', 1, 1, 1440911410581213417, '管理员', '2019-09-19 10:31:05', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1174511244036587521, 'org_category', '部门', '2', '部门', 1, 1, 1440911410581213417, '管理员', '2019-09-19 10:31:16', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1178295553450061826, 'form_perms_type', '可编辑(未授权禁用)', '2', '', 2, 1, 1440911410581213417, '管理员', '2019-09-29 21:08:46', 1440911410581213417, '管理员', '2019-09-29 21:09:18');
INSERT INTO `sys_dict_item` VALUES (1178295639554928641, 'form_perms_type', '可见(未授权不可见)', '1', '', 1, 1, 1440911410581213417, '管理员', '2019-09-29 21:09:06', 1440911410581213417, '管理员', '2019-09-29 21:09:24');
INSERT INTO `sys_dict_item` VALUES (1199517884758368257, 'urgent_level', '一般', '1', '', 1, 1, 1440911410581213417, '管理员', '2019-11-27 10:38:44', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1199517914017832962, 'urgent_level', '重要', '2', '', 1, 1, 1440911410581213417, '管理员', '2019-11-27 10:38:51', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1199517941339529217, 'urgent_level', '紧急', '3', '', 1, 1, 1440911410581213417, '管理员', '2019-11-27 10:38:58', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1199518186144276482, 'eoa_plan_type', '日常记录', '1', '', 1, 1, 1440911410581213417, '管理员', '2019-11-27 10:39:56', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1199518214858481666, 'eoa_plan_type', '本周工作', '2', '', 1, 1, 1440911410581213417, '管理员', '2019-11-27 10:40:03', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1199518235943247874, 'eoa_plan_type', '下周计划', '3', '', 1, 1, 1440911410581213417, '管理员', '2019-11-27 10:40:08', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1199520817285701634, 'eoa_cms_menu_type', '列表', '1', '', 1, 1, 1440911410581213417, '管理员', '2019-11-27 10:50:24', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1199520835035996161, 'eoa_cms_menu_type', '链接', '2', '', 1, 1, 1440911410581213417, '管理员', '2019-11-27 10:50:28', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1199525468672405505, 'eoa_plan_status', '未开始', '0', '', 1, 1, 1440911410581213417, '管理员', '2019-11-27 11:08:52', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1199525490575060993, 'eoa_plan_status', '进行中', '1', '', 1, 1, 1440911410581213417, '管理员', '2019-11-27 11:08:58', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1199525506429530114, 'eoa_plan_status', '已完成', '2', '', 1, 1, 1440911410581213417, '管理员', '2019-11-27 11:09:02', 1440911410581213417, '管理员', '2019-11-27 11:10:02');
INSERT INTO `sys_dict_item` VALUES (1209733775114702850, 'database_type', 'MySQL5.5', '1', '', 1, 1, 1440911410581213417, '管理员', '2019-12-25 15:13:02', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1209733839933476865, 'database_type', 'Oracle', '2', '', 3, 1, 1440911410581213417, '管理员', '2019-12-25 15:13:18', 1440911410581213417, '管理员', '2021-07-15 13:44:08');
INSERT INTO `sys_dict_item` VALUES (1209733903020003330, 'database_type', 'SQLServer', '3', '', 4, 1, 1440911410581213417, '管理员', '2019-12-25 15:13:33', 1440911410581213417, '管理员', '2021-07-15 13:44:11');
INSERT INTO `sys_dict_item` VALUES (1232913424813486081, 'ol_form_biz_type', '官方示例', 'demo', '', 1, 1, 1440911410581213417, '管理员', '2020-02-27 14:20:42', 1440911410581213417, '管理员', '2020-02-27 14:21:37');
INSERT INTO `sys_dict_item` VALUES (1232913493717512194, 'ol_form_biz_type', '流程表单', 'bpm', '', 2, 1, 1440911410581213417, '管理员', '2020-02-27 14:20:58', 1440911410581213417, '管理员', '2020-02-27 14:22:20');
INSERT INTO `sys_dict_item` VALUES (1232913605382467585, 'ol_form_biz_type', '测试表单', 'temp', '', 4, 1, 1440911410581213417, '管理员', '2020-02-27 14:21:25', 1440911410581213417, '管理员', '2020-02-27 14:22:16');
INSERT INTO `sys_dict_item` VALUES (1232914232372195330, 'ol_form_biz_type', '导入表单', 'bdfl_include', '', 5, 1, 1440911410581213417, '管理员', '2020-02-27 14:23:54', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1234371726545010689, 'rule_conditions', '左模糊', 'LEFT_LIKE', '左模糊', 7, 1, 1440911410581213417, '管理员', '2020-03-02 14:55:27', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1234371809495760898, 'rule_conditions', '右模糊', 'RIGHT_LIKE', '右模糊', 7, 1, 1440911410581213417, '管理员', '2020-03-02 14:55:47', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1242300779390357505, 'remindMode', '短信提醒', '2', '', 2, 1, 1440911410581213417, '管理员', '2020-03-24 12:02:41', 1440911410581213417, '管理员', '2020-03-30 18:21:33');
INSERT INTO `sys_dict_item` VALUES (1242300814383435777, 'remindMode', '邮件提醒', '1', '', 1, 1, 1440911410581213417, '管理员', '2020-03-24 12:02:49', 1440911410581213417, '管理员', '2020-03-30 18:21:26');
INSERT INTO `sys_dict_item` VALUES (1242300887343353857, 'remindMode', '系统消息', '4', '', 4, 1, 1440911410581213417, '管理员', '2020-03-24 12:03:07', 1440911410581213417, '管理员', '2020-03-30 18:21:43');
INSERT INTO `sys_dict_item` VALUES (1250688147579228161, 'quartz_status', '正常', '0', '', 1, 1, 1440911410581213417, '管理员', '2020-04-16 15:31:05', 1440911410581213417, '管理员', '2019-04-26 18:39:11');
INSERT INTO `sys_dict_item` VALUES (1250688201064992770, 'quartz_status', '停止', '-1', '', 1, 1, 1440911410581213417, '管理员', '2020-04-16 15:31:18', 1440911410581213417, '管理员', '2019-04-26 18:39:11');
INSERT INTO `sys_dict_item` VALUES (1280401815068295170, 'tenant_status', '正常', '1', '', 1, 1, 1440911410581213417, '管理员', '2020-07-07 15:22:36', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1280401847607705602, 'tenant_status', '冻结', '0', '', 1, 1, 1440911410581213417, '管理员', '2020-07-07 15:22:44', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1305827309355302914, 'online_graph_data_type', 'API', 'api', '', 3, 1, 1440911410581213417, '管理员', '2020-09-15 19:14:26', 1440911410581213417, '管理员', '2020-09-15 19:14:41');
INSERT INTO `sys_dict_item` VALUES (1334440962954936321, 'database_type', 'MYSQL5.7+', '4', '', 2, 1, 1440911410581213417, '管理员', '2020-12-03 18:16:02', 1440911410581213417, '管理员', '2021-07-15 13:44:29');
INSERT INTO `sys_dict_item` VALUES (1356445705549975553, 'is_open', '是', 'Y', '', 1, 1, 1440911410581213417, '管理员', '2021-02-02 11:33:52', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1356445754212290561, 'is_open', '否', 'N', '', 1, 1, 1440911410581213417, '管理员', '2021-02-02 11:34:04', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1414837074500976641, 'database_type', 'postgresql', '6', '', 5, 1, 1440911410581213417, '管理员', '2021-07-13 14:40:20', 1440911410581213417, '管理员', '2021-07-15 13:44:15');
INSERT INTO `sys_dict_item` VALUES (1415547541091504129, 'database_type', 'marialDB', '5', '', 6, 1, 1440911410581213417, '管理员', '2021-07-15 13:43:28', 1440911410581213417, '管理员', '2021-07-15 13:44:23');
INSERT INTO `sys_dict_item` VALUES (1418049969003089922, 'database_type', '达梦', '7', '', 7, 1, 1440911410581213417, '管理员', '2021-07-22 11:27:13', 1440911410581213417, '管理员', '2021-07-22 11:27:30');
INSERT INTO `sys_dict_item` VALUES (1418050017053036545, 'database_type', '人大金仓', '8', '', 8, 1, 1440911410581213417, '管理员', '2021-07-22 11:27:25', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1418050075555188737, 'database_type', '神通', '9', '', 9, 1, 1440911410581213417, '管理员', '2021-07-22 11:27:39', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1418050110669901826, 'database_type', 'SQLite', '10', '', 10, 1, 1440911410581213417, '管理员', '2021-07-22 11:27:47', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1418050149475602434, 'database_type', 'DB2', '11', '', 11, 1, 1440911410581213417, '管理员', '2021-07-22 11:27:56', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1418050209823248385, 'database_type', 'Hsqldb', '12', '', 12, 1, 1440911410581213417, '管理员', '2021-07-22 11:28:11', 1440911410581213417, '管理员', '2021-07-22 11:28:27');
INSERT INTO `sys_dict_item` VALUES (1418050323111399425, 'database_type', 'Derby', '13', '', 13, 1, 1440911410581213417, '管理员', '2021-07-22 11:28:38', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1418117316707590146, 'database_type', 'H2', '14', '', 14, 1, 1440911410581213417, '管理员', '2021-07-22 15:54:50', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1418491604048449537, 'database_type', '其他数据库', '15', '', 15, 1, 1440911410581213417, '管理员', '2021-07-23 16:42:07', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1418050363111399425, 'bpm_process_type', '测试流程', 'test', NULL, 1, 1, 1440911410581213417, '管理员', '2019-03-22 19:27:05', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1418051363161399425, 'online_graph_display_template', '单排布局', 'single', NULL, 2, 1, 1440911410581213417, '管理员', '2022-07-12 17:43:39', 1440911410581213417, '管理员', '2019-04-12 17:43:57');
INSERT INTO `sys_dict_item` VALUES (1418051463164399425, 'ceshi_online', '000', '00', NULL, 1, 1, 1440911410581213417, '管理员', '2019-03-22 16:34:34', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1418053663164399425, 'online_graph_display_template', '组合布局', 'combination', '', 4, 1, 1440911410581213417, '管理员', '2019-05-11 16:07:08', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1368053663164399425, 'msgType', '文本', '1', '', 1, 1, 1440911410581213417, '管理员', '2023-02-28 10:50:36', 1440911410581213417, '管理员', '2022-07-04 16:29:21');
INSERT INTO `sys_dict_item` VALUES (12134367856700834, 'rule_conditions', '不等于', '!=', '不等于', 3, 1, 1440911410581213417, '管理员', '2019-04-01 16:46:15', 1440911410581213417, '管理员', '2019-04-01 17:48:40');
INSERT INTO `sys_dict_item` VALUES (12129867856700834, 'rule_conditions', '小于等于', '<=', '小于等于', 6, 1, 1440911410581213417, '管理员', '2019-04-01 16:44:34', 1440911410581213417, '管理员', '2019-04-01 17:49:10');
INSERT INTO `sys_dict_item` VALUES (12123654856700834, 'valid_status', '有效', '1', '有效', 2, 1, 1440911410581213417, '管理员', '2019-04-26 19:22:01', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (12123446856700834, 'send_status', '已发布', '1', '已发布', 2, 1, 1440911410581213417, '管理员', '2019-04-16 17:41:24', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (12111346856700834, 'send_status', '未发布', '0', '未发布', 1, 1, 1440911410581213417, '管理员', '2019-04-16 17:41:12', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (12110966856700834, 'online_graph_data_type', 'JSON', 'json', NULL, 1, 1, 1440911410581213417, '管理员', '2019-04-12 17:26:33', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (12110966046400834, 'msgSendStatus', '发送失败', '2', NULL, 3, 1, 1440911410581213417, '管理员', '2019-04-12 18:20:02', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (12110966547800834, 'bpm_status', '已完成', '3', '已完成', 3, 1, 1440911410581213417, '管理员', '2019-05-09 16:33:25', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (12472096547800834, 'msg_category', '通知公告', '1', NULL, 1, 1, 1440911410581213417, '管理员', '2019-04-22 18:01:57', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (12473726547800834, 'rule_conditions', '等于', '=', '等于', 4, 1, 1440911410581213417, '管理员', '2019-04-01 16:45:24', 1440911410581213417, '管理员', '2019-04-01 17:49:00');
INSERT INTO `sys_dict_item` VALUES (12423215458700834, 'status', '正常', '1', NULL, NULL, 1, 1440911410581213417, '管理员', '2019-03-18 21:45:51', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (19923215458700834, 'log_type', '操作日志', '2', NULL, NULL, 1, 1440911410581213417, '管理员', '2019-03-18 23:22:49', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (19997015458700834, 'bpm_process_type', '业务办理', 'business', NULL, 3, 1, 1440911410581213417, '管理员', '2023-04-22 19:28:05', 1440911410581213417, '管理员', '2019-03-22 23:24:39');
INSERT INTO `sys_dict_item` VALUES (19997018848700834, 'yn', '是', '1', '', 1, 1, 1440911410581213417, '管理员', '2019-05-22 19:29:45', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (19151508848700834, 'perms_type', '显示', '1', '显示', 1, 1, 1440911410581213417, '管理员', '2025-03-26 18:27:13', 1440911410581213417, '管理员', '2019-04-26 18:39:07');
INSERT INTO `sys_dict_item` VALUES (19151544548700834, 'rule_conditions', '自定义SQL表达式', 'USE_SQL_RULES', '自定义SQL表达式', 9, 1, 1440911410581213417, '管理员', '2019-04-01 10:45:24', 1440911410581213417, '管理员', '2019-04-01 17:49:27');
INSERT INTO `sys_dict_item` VALUES (19151544548775634, 'cgform_table_type', '主表', '2', NULL, 2, 1, 1440911410581213417, '管理员', '2019-03-27 10:13:36', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (19154894548775634, 'msg_type', '全体用户', 'ALL', NULL, NULL, 1, 1440911410581213417, '管理员', '2020-10-17 21:22:43', 1440911410581213417, '管理员', '2019-03-28 22:17:09');
INSERT INTO `sys_dict_item` VALUES (19154894974775634, 'operate_type', '修改', '3', '', 3, 1, 1440911410581213417, '管理员', '2019-07-22 10:55:07', 1440911410581213417, '管理员', '2019-07-22 10:55:41');
INSERT INTO `sys_dict_item` VALUES (19377894974775634, 'sex', '女', '2', NULL, 2, 1, 1440911410581213417, '管理员', '2019-01-04 14:56:56', 1440911410581213417, '管理员', '2019-01-04 17:38:12');
INSERT INTO `sys_dict_item` VALUES (19375624974775634, 'rule_conditions', '大于', '>', '大于', 1, 1, 1440911410581213417, '管理员', '2019-04-01 10:45:46', 1440911410581213417, '管理员', '2019-04-01 17:48:29');
INSERT INTO `sys_dict_item` VALUES (19357824974775634, 'ceshi_online', 'easyui', '3', NULL, 1, 1, 1440911410581213417, '管理员', '2019-03-22 16:32:15', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (19357823464775634, 'msgSendStatus', '未发送', '0', NULL, 1, 1, 1440911410581213417, '管理员', '2019-04-12 18:19:23', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (19357896564775634, 'msgType', '富文本', '2', '', 2, 1, 1440911410581213417, '管理员', '2031-02-28 10:50:44', 1440911410581213417, '管理员', '2022-07-04 16:29:30');
INSERT INTO `sys_dict_item` VALUES (19357897514775634, 'cgform_table_type', '单表', '1', NULL, 1, 1, 1440911410581213417, '管理员', '2019-03-27 10:13:29', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (19357897514793234, 'rule_conditions', '模糊', 'LIKE', '模糊', 7, 1, 1440911410581213417, '管理员', '2019-04-01 16:46:02', 1440911410581213417, '管理员', '2019-04-01 17:49:20');
INSERT INTO `sys_dict_item` VALUES (19357897514793884, 'priority', '高', 'H', '高', 1, 1, 1440911410581213417, '管理员', '2019-04-16 17:04:24', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (19872789714793884, 'user_type', '333', '333', NULL, NULL, 1, 1440911410581213417, '管理员', '2019-02-21 19:59:47', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (19873599714793884, 'online_graph_type', '柱状图', 'bar', NULL, 1, 1, 1440911410581213417, '管理员', '2019-04-12 17:05:17', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (19873451514793884, 'bpm_process_type', 'OA办公', 'oa', NULL, 2, 1, 1440911410581213417, '管理员', '2021-03-22 19:27:17', 1440911410581213417, '管理员', '2019-03-22 23:24:36');
INSERT INTO `sys_dict_item` VALUES (19871774514793884, 'depart_status', '不启用', '0', NULL, NULL, 1, 1440911410581213417, '管理员', '2019-03-18 23:29:41', 1440911410581213417, '管理员', '2019-03-18 23:29:54');
INSERT INTO `sys_dict_item` VALUES (19871444514793884, 'depart_status', '启用', '1', NULL, NULL, 1, 1440911410581213417, '管理员', '2019-03-18 23:29:28', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (19878441514793884, 'user_status', '正常', '1', NULL, NULL, 1, 1440911410581213417, '管理员', '2019-03-18 23:30:28', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (19878443714793884, 'menu_type', '按钮权限', '2', NULL, NULL, 1, 1440911410581213417, '管理员', '2019-03-18 23:25:40', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (19878443714793330, 'user_status', '冻结', '2', NULL, NULL, 1, 1440911410581213417, '管理员', '2019-03-18 23:30:37', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (15457844714793330, 'global_perms_type', '可见/可访问(授权后可见/可访问)', '1', '', 1, 1, 1440911410581213417, '管理员', '2019-05-10 17:54:51', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (15457154714793330, 'rule_conditions', '大于等于', '>=', '大于等于', 5, 1, 1440911410581213417, '管理员', '2019-04-01 10:46:02', 1440911410581213417, '管理员', '2019-04-01 17:49:05');
INSERT INTO `sys_dict_item` VALUES (15457990714793330, 'online_graph_type', '饼图', 'pie', NULL, 3, 1, 1440911410581213417, '管理员', '2019-04-12 17:05:49', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (15511990714793330, 'bpm_status', '处理中', '2', '处理中', 2, 1, 1440911410581213417, '管理员', '2019-05-09 16:33:01', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (15511964114793330, 'dict_item_status', '启用', '1', '', 0, 1, 1440911410581213417, '管理员', '2020-07-18 23:19:27', 1440911410581213417, '管理员', '2019-05-17 14:51:18');
INSERT INTO `sys_dict_item` VALUES (12511964114793330, 'global_perms_type', '可编辑(未授权时禁用)', '2', '', 2, 1, 1440911410581213417, '管理员', '2019-05-10 17:55:38', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (12511964113693330, 'priority', '中', 'M', '中', 2, 1, 1440911410581213417, '管理员', '2019-04-16 17:04:40', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (12513764113693330, 'operate_type', '添加', '2', '', 2, 1, 1440911410581213417, '管理员', '2019-07-22 10:54:59', 1440911410581213417, '管理员', '2019-07-22 10:55:36');
INSERT INTO `sys_dict_item` VALUES (12510781113693330, 'dict_item_status', '不启用', '0', NULL, 1, 1, 1440911410581213417, '管理员', '2019-03-18 23:19:53', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (12572741113693330, 'operate_type', '导出', '6', '', 6, 1, 1440911410581213417, '管理员', '2019-07-22 12:06:50', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (12572741113663780, 'send_status', '已撤销', '2', '已撤销', 3, 1, 1440911410581213417, '管理员', '2019-04-16 17:41:39', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (12572741118923780, 'menu_type', '一级菜单', '0', NULL, NULL, 1, 1440911410581213417, '管理员', '2019-03-18 23:24:52', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (12572747818923780, 'rule_conditions', '包含', 'IN', '包含', 8, 1, 1440911410581213417, '管理员', '2019-04-01 16:45:47', 1440911410581213417, '管理员', '2019-04-01 17:49:24');
INSERT INTO `sys_dict_item` VALUES (12572747862623780, 'msg_category', '系统消息', '2', NULL, 1, 1, 1440911410581213417, '管理员', '2019-02-22 18:02:08', 1440911410581213417, '管理员', '2019-04-22 18:02:13');
INSERT INTO `sys_dict_item` VALUES (12572747867373780, 'del_flag', '正常', '0', NULL, NULL, 1, 1440911410581213417, '管理员', '2022-10-18 21:46:48', 1440911410581213417, '管理员', '2019-03-28 22:22:20');
INSERT INTO `sys_dict_item` VALUES (12572780507373780, 'user_type', '22', '222', NULL, NULL, 0, 1440911410581213417, '管理员', '2019-02-21 19:59:43', 1440911410581213417, '管理员', '2019-03-11 21:23:27');
INSERT INTO `sys_dict_item` VALUES (12578880507373780, 'valid_status', '无效', '0', '无效', 1, 1, 1440911410581213417, '管理员', '2019-04-26 19:21:49', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (12578865407373780, 'bpm_status', '待提交', '1', '待提交', 1, 1, 1440911410581213417, '管理员', '2019-05-09 16:32:35', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (13626865407373780, 'activiti_sync', '同步', '1', '同步', 1, 1, 1440911410581213417, '管理员', '2019-05-15 15:28:15', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (13626865407378778, 'operate_type', '导入', '5', '', 5, 1, 1440911410581213417, '管理员', '2019-07-22 12:06:41', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (13626865475378778, 'operate_type', '查询', '1', '', 1, 1, 1440911410581213417, '管理员', '2019-07-22 10:54:51', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (13628265475378778, 'yn', '否', '0', '', 1, 1, 1440911410581213417, '管理员', '2019-05-22 19:29:55', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (13628265473365778, 'online_graph_type', '曲线图', 'line', NULL, 2, 1, 1440911410581213417, '管理员', '2019-05-12 17:05:30', 1440911410581213417, '管理员', '2019-04-12 17:06:06');
INSERT INTO `sys_dict_item` VALUES (13636265473365778, 'online_graph_type', '数据列表', 'table', NULL, 4, 1, 1440911410581213417, '管理员', '2019-04-12 17:05:56', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (13636266473575778, 'sex', '男', '1', NULL, 1, 1, 1440911410581213417, '管理员', '2027-08-04 14:56:49', 1440911410581213417, '管理员', '2019-03-23 22:44:44');
INSERT INTO `sys_dict_item` VALUES (13636266477865778, 'rule_conditions', '小于', '<', '小于', 2, 1, 1440911410581213417, '管理员', '2019-04-01 16:44:15', 1440911410581213417, '管理员', '2019-04-01 17:48:34');
INSERT INTO `sys_dict_item` VALUES (136362653177865778, 'activiti_sync', '不同步', '0', '不同步', 2, 1, 1440911410581213417, '管理员', '2019-05-15 15:28:28', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1363665153177865778, 'ceshi_online', 'booostrap', '1', NULL, 1, 1, 1440911410581213417, '管理员', '2021-08-22 16:32:04', 1440911410581213417, '管理员', '2019-03-22 16:33:57');
INSERT INTO `sys_dict_item` VALUES (1363625153172265778, 'msgSendStatus', '发送成功', '1', NULL, 2, 1, 1440911410581213417, '管理员', '2019-04-12 18:19:43', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1363653153172265778, 'status', '冻结', '2', NULL, NULL, 1, 1440911410581213417, '管理员',  '2019-03-18 21:46:02', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1363653153172395778, 'log_type', '登录日志', '1', NULL, NULL, 1, 1440911410581213417, '管理员', '2019-03-18 23:22:37', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1368053153172395778, 'online_graph_display_template', '双排布局', 'double', NULL, 3, 1, 1440911410581213417, '管理员', '2019-04-12 17:43:51', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1368053153172395725, 'operate_type', '删除', '4', '', 4, 1, 1440911410581213417, '管理员', '2019-07-22 10:55:14', 1440911410581213417, '管理员', '2019-07-22 10:55:30');
INSERT INTO `sys_dict_item` VALUES (1368053153172399425, 'online_graph_display_template', 'Tab风格', 'tab', NULL, 1, 1, 1440911410581213417, '管理员', '2019-04-12 17:43:31', 1440911410581213417, '管理员', '2019-04-16 17:04:59');
INSERT INTO `sys_dict_item` VALUES (1368053153164399425, 'bpm_status', '已作废', '4', '已作废', 4, 1, 1440911410581213417, '管理员', '2021-09-09 16:33:43', 1440911410581213417, '管理员', '2019-05-09 16:34:40');



SET FOREIGN_KEY_CHECKS = 1;

